Excel Formulas to Replace One Character with Another ~ Quickly!!

If you need to make edits to a large body of text, Excel’s functions can make the process much easier. Both the REPLACEand SUBSTITUTEfunctions can help—but they both do it differently. Let’s take a look at how to replace one character with another in Excel. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

• If you want to replace the character with one another, you can use the below formula.

=SUBSTITUTE(A1,old,new)

Syntax Explanations:

• *SUBSTITUTE * – This function can replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the SUBSTITUTE ** function**.
• *A1 * – It represents the input value.
• Old – It specifies the character that you want to replace.
• New – It represents the new character.
• Comma symbol (,) – It is a separator that helps to separate a list of values.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

• First, we will enter the input values in Column B.
• Here we need to replace the space character.

• Select any cell and type the above-given formula.

• Finally, press the ** ENTER** key, you can get the result as shown below.

Bottom-Line:

Hope you like this article on how to replace the character with one another in Excel. Please feel free to state your query or feedback for the above article.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Ahead:

• Excel Formulas to Remove the Unwanted Characters ~ Easy Tricks!!
• Formulas for Counting Rows that Matches Two or More Criteria in Excel!!
• Excel Formulas to Remove the Text By Variable Position ~ Quickly!!
• Excel Formulas to Remove the Text By Position ~ Simple Tutorial!!