MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combining Columns

Posted by JIM BYRNE on July 23, 2001 12:29 PM

I have a file with city, state, zip in seperate columns. Does anyone know how I can merge them into one column. Any help would be appreciated.

Posted by Aladin Akyurek on July 23, 2001 12:35 PM

Let City be in A1, State in B1, and Zip in C1.

In D1 enter: =A1&" "&B1&" "&C1

Copy down as far as needed.