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