Mindy

Merging leaves only the data in the left-most cell.

A work-around is to add the contents together.

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

I would not combine those columns. Most applications that would use those
addresses would prefer that the fields be in separate cells.

Word mailmerge for one would choke on the addresses being all in one cell.


Gord Dibben Excel MVP

On Mon, 18 Apr 2005 12:20:02 -0700, "Mindy"
wrote:

Hi, I have a spreadsheet with columns for address, city, state, and zip. I'm
trying to merge those columns but it only keeps the data in the address
column. . why is that? Mindy