How do I put an adress in a cell in multiple lines??

S

starguy

enter like this

type "Santa Claus" then press Alt+Enter
then type "101 Sana Street" and press Alt+Enter
type "North Pole" and press Alt+Enter
type "H0H 0H0" and press Alt+Enter

hope you got what you required.
 
G

Gord Dibben

Jill

You have had several answers showing you how to do what you want.

My answer is.........DO NOT DO IT!!

You will eventually need those addresses to be sorted or exported or mail merged
etc.

You will not be able to work with those addresses in the format you ask for and
have to split them out into cells......which is not impossible, just an
unnecessary step

My advice is keep the parts in separate cells in a row in 4 or 5 columns.

Name..........Street number........Street.........City.........Postal Code


Gord Dibben MS Excel MVP
 
D

Dave Peterson

And just to add to Gord's advice...

If you really need to have this stuff in a single cell, don't do your data entry
that way.

Lay it out in separate cells in a single row per person.

You can always combine the values into another cell if you absolutely want to
later (either by formulas or by code).
 
Top