multi-line cells

  • Thread starter Thread starter Steve Williams
  • Start date Start date
S

Steve Williams

Hi,

I need to be able to put some multi-line data into single cells in an excel
spreadsheed. In particular, I want to put in the full address of clients
without putting the address parts in a group of cells. I want to be able to
write the address just as I would on an envelope.

I can't seem to get excell to take the carriage return character in a single
cell's input. Can anyone help?

Thanks in advance,

Steve
 
Think twice before you do this.

If you separate the address fields into different columns, you can always
combine them with a formula like:

=a1&char(10)&b1&char(10)&c1

(char(10) is the same as the alt-enter key that Bob described.)

But by using a single column for each part of the address, you'll be able to do
lots more with your data.

(Sorting/filtering especially)

And you can use Word's MailMerge to print your envelopes.

And you didn't ask, but here's a couple of links that you may want to review:

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