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



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


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

Or you can do this:


It should work!