And multiple duplicated answers create a problem for you
because.....................?


Gord Dibben MS Excel MVP

On Tue, 22 May 2007 06:00:01 -0700, Joel wrote:

David: Before posting your suggestions, look at other posting first. You
often give the same answers that have been previously posted.

"David Biddulph" wrote:

Format/ Cells/ Alignment: tick Wrap text.
--
David Biddulph

"Wanna Learn" wrote in message
...
Hello this is my formula
=Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10) &Address2)
I want the title and name on one line and on the next line address 1 then
address 2 on the next line, if any. this formula shows everything is on
ONE
LINE what's wrong
Thanks