Apr 01 2022 11:35 AM
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".
Apr 01 2022 03:44 PM
Apr 01 2022 09:47 PM
@WHague80 As a variant:
=TEXT(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),"000-000-0000")
where A1 contains the phone number like (nnn)nnnnnnn