Merge Columns

[Templar]

Never thought that this would be such a hassle. I have one column with
area codes and the next with phone numbers without area codes. I simply
want to merge the area codes before the telephone number INTO ONE COLUMN.

All I can find is merge cell shortcuts in the new Excel program. Nothing is
telling
me how to do what seems to be or should be a very simple task.

Please advise.
Thank you.

 

[Mike H]

Maybe this in a 3rd column

=A1&B1

or to preserve some spacing

=A1&" "&B1

You then then copy this column and paste it back over itself with
pastespecial - paste values and delete the original 2 columns.

Mike

 

[Gord Dibben]

In C1 enter =A1 & B1

Or maybe

Copy down.

Assumes are codes in A and ph. numbers in B

Copy/paste special(in place)>Values>OK>Esc.

Format as Special>Phone Number


Gord Dibben MS Excel MVP