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

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

You can use alt-enter to force a new line within the cell.

If you see a square box, you can toggle this setting:
format|cells|Alignment tab|check Wrap Text

This is actually a line-feed character (x0010), not the carriage return (x0013).



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

--

Dave Peterson

I would not place all this information in one cell.

Most programs expect address fileds to be in separtate cells.

Having said that..........ALT + Enter will create a carriage return in a cell.


Gord Dibben MS Excel MVP

On Mon, 7 Aug 2006 12:26:02 -0700, 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