MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combining columns


Posted by J.D. on September 10, 2001 12:16 PM

I'd like to know how to combine 3 columns into 1. The columns are telephone numbers, i.e;
area code prefix suffix

I'd like them to appear as:
area code-prefix-suffix
in 1 column

Thanks,

J.D.


Posted by Ben O. on September 10, 2001 12:18 PM

In column D enter this formula and fill it all the way down:

=A2 & "-" & B2 & "-" & C2

-Ben

Posted by Tan Le on September 10, 2001 10:08 PM

Or you can do this:

=concatenate(A2,"-",B2,"-",C2)

It should work!

TL