Forum Discussion
WHague80
Apr 01, 2022Copper Contributor
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 time finding the source of information on how to convert a column that has this data format "(nnn) nnnnnnn" to the format I want as "nnn-nnn-nnnn".
2 Replies
- Riny_van_EekelenPlatinum Contributor
WHague80 As a variant:
=TEXT(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),"000-000-0000")
where A1 contains the phone number like (nnn)nnnnnnn