REPLACE Function

How to Find and Replace Asterisk (*) Character in Excel

While working with Microsoft Excel, we occasionally have to change the data and to do so, we must replace terms with other terms or letters and ...

How to Add Dashes to SSN in Excel (6 Methods)

Microsoft Excel offers multiple ways to add dashes to the social security numbers (SSNs). You can use formulas or Format Cells dialog box to add ...

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 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 Format Phone Number with Dashes in Excel (2 Ways)

Sometimes we need to deal with datasets packed with random phone numbers without formatting. Using and understanding those phone numbers is difficult ...

How to Remove Parentheses from Phone Numbers in Excel (5 Methods)

This article provides some basic ideas on how to remove parentheses from phone numbers in Excel. Suppose you want to save some phone numbers of some ...

Excel Formula to Change Phone Number Format (5 Examples)

In this article, we’re going to show you 5 methods of creating an Excel formula to change phone number format. To demonstrate our methods we’ve ...

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 Using Formula in Excel (4 Examples)

This article will help you to understand the find and replace formula(s) in Excel. Sometimes we need to edit our data in Excel sheets and for that ...

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 ...

ExcelDemy
Logo