View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rockies_Hunter
 
Posts: n/a
Default I need help getting data from two columns into one

I need help getting phone numbers I have in an Excel spread sheet ready to
import into Business Contact Manager. Currently I have area codes in one
column and phone numbers in another. In order to import my contacts into BCM
I need to get the codes and the numbers into the same column. Can anyone
tell me how to do this?
A B to A
[704] [555-1212] to [704 555-1212]

Thanks