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.

Marcdavid62 wrote:

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?

"Dave Peterson" wrote:

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

Marcdavid62 wrote:

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?

--

Dave Peterson


--

Dave Peterson