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.
Aladin
