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