REPLACE Function Archives

How to Remove Sign in Excel (With 3 Examples)

Jun 20, 2022 Excel Basics

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)

Jun 2, 2022 Excel Basics

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)

Jun 19, 2022 Excel Formulas

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)

Jun 1, 2022 Excel Formulas

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)

Jun 1, 2022 Excel Formulas

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)

Jun 1, 2022 Excel Formulas

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)

May 29, 2022 Excel Formulas

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)

Apr 21, 2022 Excel Formulas

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

May 26, 2022 Excel Basics

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)

Apr 25, 2022 Excel Basics

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)

May 29, 2022 Excel Formulas

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)

Jun 4, 2022 Excel Formulas

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)

Apr 6, 2022 Excel Formulas

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)

May 29, 2022 Excel Formulas

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)

May 11, 2022 Excel Basics

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