Forum Discussion

Copper Contributor

Apr 01, 2022

Reformatting a column to proper phone number

Good morning! I frequently download .csv files from Veterans of Foreign Wars of the United States that then need to have several columns reformatted for my in-house use. I'm having a devil of a...

office 365

Riny_van_Eekelen

Platinum Contributor

Apr 02, 2022

WHague80 As a variant:

=TEXT(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),"000-000-0000")

where A1 contains the phone number like (nnn)nnnnnnn