I also agree with Russell.

cmckeever
"Russell Dawson" wrote in message
...
Hi

Whilst other members have answered your question you may wish to consider
the following.

From what you have said I anticipate that you would at some stage need to
mail all your members. I can see what you are trying to do but perhaps if
you were to set up your s/s so that each consecutive cell in a row has
<name<address 1st line<address 2nd line<zip/post code< or something like
that; you will then be able to do a mailmerge frpm Word rather than print
the
labels as you appear to intend.

Apologies if this is something you have already considered and dismissed.


--
Russell Dawson
Excel student


"Wentworth" wrote:

,I am using Office XPPro (PC) but although I used Word a lot before I
retired
I am only now trying to do things in Excel (and incidentally Access).

I want to put the membership records of a club into an Excel spreadsheet
and
to show each postal address divided (as it would be on an envelope) into
several lines, some of them short. Since, when I am typing in data,
pressing
the Return key takes me to the next cell, not the next line, at present
wherever I want a line break I am having to put in enough extra spaces to
push the next word over the edge of the cell so that it wraps into the
next
line. I feel there must be a simpler way and would be grateful for help
in
finding it.