That is a newsgroup featu there is a delay between the time you post your
message and the time when David gets to read it. So he does not know an
answer has been sent. There is no harm with duplicates; even a slight
difference in the way the answer is presented can make it easier for the OP
to understand what to do.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Joel" wrote in message
...
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