REPLACE Function Archives

REPLACE Function

How to Insert Character Between Text in Excel (5 Easy Methods)

Aug 4, 2022 Excel Formulas

If you want to insert character between text in Excel, this article is for you. Here, we will walk you through 5 easy and effective methods to do the ...

How to Add Comma in Excel Between Names (4 Suitable Ways)

Jul 31, 2022 Excel Formulas

If you are searching for the solution or some special tricks to how to add comma in Excel between names then you have landed in the right place. ...

How to Make First Letter of Sentence Capital in Excel (4 Suitable Methods)

Jul 7, 2022 Excel Formulas

Excel has some built-in function that helps capitalize the first letter of a sentence. This article will discuss how to make the first letter of ...

How to Capitalize First Letter of Sentence in Excel (6 Suitable Methods)

Jul 5, 2022 Excel Basics

Excel is not only for numerical values but also you may need to work with text data. So, if you know how to capitalize the first letter of a sentence ...

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)

Jun 28, 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 ...