Reformatting a column to proper phone number

Occasional Visitor

  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




@WHague80 As a variant:


where A1 contains the phone number like (nnn)nnnnnnn