Another way is to use this formula, copied down, and set formatting for
Wrap-text.......it will put each item on a separate line in the same cell

=A1&CHAR(10)&B1&CHAR(10)&C1&CHAR(10)&D1

hth
Vaya con Dios,
Chuck, CABGx3



"SassyB" wrote:

I have an excel spreadsheet that has the street address, city, state, and zip
for employees in 4 separate columns. Is there a quick way to merge the 4
columns to 1 while keeping all of the data?