Reformatting a column to proper phone number

Copper Contributor

  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

@WHague80 Use a formula as shown below

 

Doug_Robbins_Word_MVP_0-1648853029854.png

 

@WHague80 As a variant:

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

where A1 contains the phone number like (nnn)nnnnnnn