multi-line cells

[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

 

[Bob Flanagan]

Steve, press ALT-ENTER to put in a line break.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Dave Peterson]

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.