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

M

Marcdavid62

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?
 
D

David Biddulph

If you're going to do a merge into Word, put the data for each line of the
label into a different column.
 
M

Marcdavid62

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?
 
D

Dave Peterson

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.
 
M

Marcdavid62

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?
 
D

Dave Peterson

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...
 
D

David Biddulph

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.
 
Top