Hello This is my formula
=FirstName&CHAR(10)&LastName&CHAR(10)&Address1&CHA R(10)&Address2&CHAR(10)&Address3&CHAR(10)&City&"
"&State&" "&TEXT(Zip,"00000") the problem is that when there is no address
2 or address 3 then I get a blank line .example below
"Mr. Jack Sparrow
Black Pearl Ltd
1400 Seaport Boulevard
0
0
Redwood City CA 94063"
Is there a way to correct this? thanks in advance