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