REPLACE Function Archives - Page 3 of 5

How to Extract Text after a Specific Text in Excel (10 Ways)

Feb 14, 2023

If you are trying to extract text after a specific text from combined texts in Excel, then you will find this article useful. So, let’s start our ...

How to Extract Text after a Specific Text in Excel (10 Ways)

How to Extract Text After Last Space in Excel (5 Ways)

Feb 12, 2023

While using Excel, we often need to strip our text Cells and need part of our data, like the need of having the last part of the word of the long ...

How to Extract Text After Last Space in Excel (5 Ways)

How to Capitalize Each Word in Excel (7 Easy Ways)

Apr 13, 2023

When we work on an Excel worksheet, sometimes we have to capitalize each word in a text. If you are facing any difficulties in doing that job, then ...

How to Capitalize Each Word in Excel (7 Easy Ways)

How to Capitalize the First Letter in Excel (3 Methods)

Feb 16, 2023

In Excel sometimes we need to change the case of the first letter from lower to upper. Do we have to change every character manually? Not anymore! ...

How to Capitalize the First Letter in Excel (3 Methods)

How to Find Excel Sheet Name Using Formula (3 Examples)

Feb 12, 2023

In a Microsoft Excel file usually, we get the sheet name from the bottom of each sheet. But there are other options to find sheet names. We will ...

How to Find Excel Sheet Name Using Formula (3 Examples)

How to Remove Currency Symbol in Excel (6 Ways)

Sep 18, 2023

While working with Excel, sometimes we notice that our data contains values in Currency Format. Excel automatically includes a Dollar symbol for the ...

How to Remove Currency Symbol in Excel (6 Ways)

How to Find and Replace Multiple Words at Once in Excel (7 Methods)

Feb 14, 2023

Often we need to replace values. In this article, we've shown you 7 methods to find and replace multiple words at once in Excel. A company previously ...

How to Find and Replace Multiple Words at Once in Excel (7 Methods)

How to Format Text to Capitalize First Letter in Excel (10 Ways)

Feb 27, 2023

Sometimes there is data in the Excel worksheet where the letter case is wrong or not in the format that you want. In this article, we will show you ...

How to Format Text to Capitalize First Letter in Excel (10 Ways)

How to Create an Excel Formula to Subtract (10 Examples)

Jul 24, 2023

Subtraction is a common operation in mathematics. In Microsoft Excel, we don't have any built-in function for subtraction. We will show how to create ...

How to Create an Excel Formula to Subtract (10 Examples)

How to Remove Last Digit in Excel (6 Quick Methods)

Mar 20, 2023

Want to remove the last digit in your Excel worksheet? You are in the right place! You can do this with some inbuilt Excel functions. Here in this ...

How to Remove Last Digit in Excel (6 Quick Methods)

How to Add Blank Space Using Excel Formula (6 Methods)

May 3, 2023

Sometimes while working with Excel you might need to add blank space before and after the cell values. You might need to add the blank spaces to ...

How to Add Blank Space Using Excel Formula (6 Methods)

How to Remove Prefix in Excel (6 Methods)

Nov 27, 2022

While working with a large dataset in Excel, sometimes we need to remove prefixes of data that are superfluous. To simplify the task, we can remove ...

How to Remove Prefix in Excel (6 Methods)

How to List Sheet Name in Excel (5 Methods + VBA)

Sep 18, 2023

In some cases, you may have dozens of named sheets in your workbook. However, if you need the list of sheet names, you can utilize the formulas. In ...

How to List Sheet Name in Excel (5 Methods + VBA)

How to Remove Specific Character from String in Excel

Sep 19, 2023

When working with text data in Excel we may have to remove an unnecessary specific character from string excel. To work conveniently we need to ...

How to Remove Specific Character from String in Excel

How to Remove Single Quotes in Excel (6 Ways)

Feb 19, 2023

Sometimes we have data with single quotes in our Excel datasheet. If the data have single quotes Excel automatically hides the leading apostrophe of ...