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.