REPLACE Function

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

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 Last Space in Excel (5 Ways)

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 Capitalize Each Word in Excel (7 Easy Ways)

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 the First Letter in Excel (3 Methods)

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 Find Excel Sheet Name Using Formula (3 Examples)

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 Remove Currency Symbol in Excel (6 Ways)

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 Find and Replace Multiple Words at Once in Excel (7 Methods)

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 Format Text to Capitalize First Letter in Excel (10 Ways)

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 Create an Excel Formula to Subtract (10 Examples)

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 Remove Last Digit in Excel (6 Quick Methods)

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 Add Blank Space Using Excel Formula (6 Methods)

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 Remove Prefix in Excel (6 Methods)

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 List Sheet Name in Excel (5 Methods + VBA)

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 Remove Specific Character from String in Excel

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 Single Quotes in Excel (6 Ways)

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

Advanced Excel Exercises with Solutions PDF