26
Excel Formulas to Clean & Reformat Telephone Numbers ~ Simple Tips!!
Suppose, you have a list of telephone numbers that are formatted with various formatting. Now, you want to clean up all the phone number formatting and reformat them with specific telephone numbers. How can use solve this problem? In this article, I will show the simple trick to achieve this job. 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(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,”(“,””),”)”,””),”-“,””),” “,””),”.”,””)+0
Refer to the below example image.



Here, we have described the simple formulas to clean and reformat the telephone numbers in Excel. Mention your queries in the comment box below.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
26