View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sharon Barr
 
Posts: n/a
Default Join three columns containing phone number and format as (000) 000

I have a large spreadsheet where the phone number is split into three
columns. I want to combine these three columns into one and format as a phone
number. Also, the last column is dropping leading zero. I need it to keep the
leading zero.