Concatenate and Mail Merge

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

Guest

I'm trying to make a mailing list out of an Excel spreadsheet. I've
concatenated the different parts of the address so that it is all in one cell
but I want the city, province and country to appear on the next line (right
now everything is in one big line).

Any suggestions on how I can insert the "enter" key into a concatenation
formula?

Thanks,
Tara

P.S. I'm using Microsoft Excel 2000
 
With the address elements in A1:E1, use:

=A1&CHAR(10)&B1&CHAR(10)&C1&CHAR(10)&D1&CHAR(10)&E1

Now format the formula cell click "Wrap Text" under Format > Cells >
Alignment tab

HTH
Jason
Atlanta, GA
 
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

Constant in concatenation 5
Concatentate text and insert blank line 2
Unable to copy the merged cell to the rest of the column 3
Vlookup using concatenated column indexes 7
Mail merge 2
Concatenate multiple lines 2
Concatenation with leading zeros 6
Function in Excel to count and list number of entries of text valuesin a row. 2

Back
Top