Entering an address in one cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Putting an Address in a Cell - 21 Oct 2006 19:03 GMT

Hi,

I am trying to put together a mailing list. I've created a table and want
to place customer addresses in corresponding cells. When I enter their
addresses and hit the Enter key, the different lines of the address don't
automatically shift to the next line. How do I do that so that the addresses
print out in a nice way, such as

Joe Smith
76 Main St.
Chicago, IL 47382

Thanks for any help!

I have a PC.

Caroline

Reply to this Message

David Biddulph - 21 Oct 2006 19:20 GMT

> Hi,
>
[quoted text clipped - 14 lines]
>
> Caroline

I would suggest that you put the lines of the address in columns of your
Excel file, and then use Mail Merge in MS Word to print out the addresses.
http://office.microsoft.com/en-us/assistance/HP052037601033.aspx

Signature

David Biddulph

Reply to this Message

Jon Peltier - 21 Oct 2006 22:20 GMT

While the long term approach is what David suggests, if all you need is a
line feed within a cell, hold Alt while pressing Enter.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> Hi,
>
[quoted text clipped - 14 lines]
>
> Caroline

Reply to this Message