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