How do I make an address label in excel, then merge it with Word.

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

Guest

i want to type an address in one cell, for instance, Mr Marc johnson 123
ardmore canton ohio 11111. When this merges with Word i want the label to
show the name address and city on 3 separate lines. how do I do this?
 
If you're going to do a merge into Word, put the data for each line of the
label into a different column.
 
Have you ever seen the text look like this, Mike Johnson||123 harvard
st||cleveland OH. the "||" somehow inserts the next few words right below,
making it look like an address on an envelope. Do you know how to do this?
 
If you're typing the address, you can hit alt-enter to force a new line in the
cell.

Make sure that Format|Cells|alignment tab|wrap text is checked.

But you're life will be much easier if you put each field into its own column.
 
For Example: the columns at the top read FIRST LAST ADDRESS
However in some of the addresses there is a "C/O John Doe" line. I want
this line to be under the address line But I do not want to hit ALT + Enter.
An example I looked at had 123 high st || C/O john Doe. The "||" symbol
somehoe makes the c/o populate below the address. does this make sense?
 
Not to me. But maybe someone else has an idea.
For Example: the columns at the top read FIRST LAST ADDRESS
However in some of the addresses there is a "C/O John Doe" line. I want
this line to be under the address line But I do not want to hit ALT + Enter.
An example I looked at had 123 high st || C/O john Doe. The "||" symbol
somehoe makes the c/o populate below the address. does this make sense?
Click to expand...
 
If your strange character is the 11th character in cell A1, try the formula
=CODE(MID(A1,11,1)) to find what character it is.
 
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

Eliminate blank fields in mail merge from Excel to Word 1
Mail Merge from Word 2
Replacing text in a cell with blanks 3
how do I remove line breaks from several cells? 6
finding and replacing text with a blank 2
Merge address in XL to Word letter template 1
MERGING CELLS WITHIN XL 2
Data from spreadsheet to Microsoft Word label document 2

Back
Top