Mark

Bernard has shown you how but do you really want to do this?

You can run into problems later when trying to sort by address numbers or street
names.

Also you may someday want to do a mailmerge for labels or such.

You should have each section in a separate cell.


Gord Dibben MS Excel MVP

On Tue, 24 Oct 2006 09:33:01 -0700, Mark wrote:

I want to place a 3 line address in one cell. Every time I try to press
"Enter" to go to the next line... it goes to the next cell. Please help.