REPLACE Function

How to Remove Sign in Excel (With 3 Examples)

We work in Excel for different purposes. Like, we work with currency-related operations, and there appear currency signs. And you could imagine a lot ...

How to Insert Dot between Numbers in Excel (3 Ways)

Sometimes, users need to insert a Dot between numbers or characters in Excel to display different parts of numbers or IDs. It’s common to insert dot ...

How to Subtract Two Columns in Excel (5 Easy Methods)

Subtraction is the process of finding the difference between two numbers or integers. If we go back to our old school memory, we used to put a minus ...

How to Replace Text with Blank Cell in Excel (5 Simple Methods)

This tutorial will demonstrate 5 simple methods to replace text with a blank cell in Excel. When working with a dataset, we may need to eliminate ...

Excel Formula to Replace Text with Number (5 Examples)

We work with texts and numbers in our Excel worksheet all the time. And sometimes, we may want to exchange the texts with numbers for various ...

How to Replace Text after Specific Character in Excel (3 Methods)

If you want to replace text after a specific character in Excel, this article is for you. Here, we will walk you through 3 simple, easy, and ...

How to Trim Part of Text in Excel (9 Easy Methods)

While working in Microsoft Excel, you may need to trim part of a text string. For example, you might require removing a certain part of a text ...

How to Remove Specific Text from a Column in Excel (8 Ways)

This article illustrates 8 different methods for how remove specific text from a column in excel. Deleting specific redundant text manually from a ...

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

ExcelDemy
Logo