If you're typing the addresses:

Hold down the [alt] key and press the [enter] key.

(That will insert a "carriage return" in the cell.)

If you're using formulas, use CHAR(10), like in this example:
="Line_1"&CHAR(10)&"Line_2"

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"chronicles_point" wrote:

creating a database. need to put address on one line and state and zip on
another but i don't know the symbol or how to get it that looks like a square
box which would create a "carriage return" to separate these two entities
without adding spaces to send the info to another line. Thank you