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

=a1&b1
or
=a1&" "&b1
or similar
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Rockies_Hunter" wrote in message
...
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