=CONCATENATE(A1," ",B1," ",C1," "D1) and fill down as needed.

Copy, paste special, values to strip the formula and return the concatenated
text string.

Dave
--
Brevity is the soul of wit.


"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?