Combining data from 2 Columns into 1

[Guest]

I have a spread sheet that needs to be imported into a pre-set form. In the spread sheet the Area Code and Phone Number are separate columns, but in the form they are a single column. How do I get both the area code and phone number in just one column? This spread sheet has multiple phone numbers for each record and hundreds of records, so it is impractical to do it all by hand.

Thanks,
J.

 

[kkknie]

How about this:

Assume area code in column a, phone number in colum b and you wan
parens around area code (i.e. (403) 723-8833).

1. Insert a column to the right of column B (new column C).
2. Enter/paste the following formula in C1:
="(" & A1 & ") " & B1
3. Copy from cell C1 down the entire C column where you have phon
numbers.
4. Select the C column and do a copy.
5. Do a Paste Special (without selecting anything else) and selec
Values. This converts the formula to text.
6. Delete columns A and B