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

Because that's the way XL is designed?

Take a look he

http://www.mcgimpsey.com/excel/udfs/multicat.html


In article ,
"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

How are you merging them ?

--
Regards,

Juan Pablo González

"Mindy" wrote in message
...
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

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