merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

printing mailing labels when data is in rows 3
How to merge Excel address columns when some zips begin with zeros 4
transpose 1 column of 100 items to 10 x 10 array 2
remove comma and text past it in cell 2
Best solution to merge multiple Outlook contacts easily 2
Move rows into columns 3
Merging multiple columns into one column (dynamically) 1
Move Rows to Columns 3

Back
Top