57
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

=SUBSTITUTE(A1,old,new)
Refer to the below example image.



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 *!! **
57