merge

M

Mindy

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
 
G

Gord Dibben

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
 
Top