Sassy

You may regret it later because if you ever wanted to use the data for a mail
merge or labels or exporting to other applications they would require the data
to be in separate cells.

Having said that...............enter this formula in column E, assuming the 4
columns are A:D

=A1 & " " & B1 & " " & C1 & " " & D1

When happy with results, copy and paste specialvalues then delete columns A:D
if you wish.


Gord Dibben MS Excel MVP

On Wed, 3 Jan 2007 08:41:00 -0800, 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?