Hope someone can help me with the formula below.

=IF(AU20,(IF(Criteria!$E$7="Y",IF(Selection!AD2=" Y","","LRA"),0))&CHAR(10)&(IF(Criteria!$E$8="Y",IF (Selection!AE2="Y","","Breakfast"),0))&CHAR(10)&(I F(Criteria!$E$9="Y",IF(Selection!AF2="Y","","Inter net"),0))&CHAR(10)&(IF(Criteria!$E$10="Y",IF(Selec tion!AG2="Y","","Tax"),0))&CHAR(10)&(IF(Criteria!$ E$11="Y",IF(Selection!AH2="Y","","Free
Parking"),0))&CHAR(10)&(IF(Criteria!$E$12="Y",IF(S election!AI2="Y","","Trsf.
to
office"),0))&CHAR(10)&(IF(Criteria!$E$13="Y",IF(Se lection!AJ2="Y","","Airport
Transfer"),0))&CHAR(10)&(IF(Criteria!$E$14="Y",IF( Selection!AN2="Y","","Cancellation
Policy"),0))&CHAR(10)&(IF(Criteria!$E$15="Y",IF(Se lection!AM2="Y","","No of
BOD"),0))&CHAR(10)&(IF(Criteria!$E$16="Y",IF(Selec tion!V2="Y","","City
Cap"),0)),"").

The current result it gives me are

LRA
0
0
0
0
0
0
0
0
City Cap

Is there a way whre I can get the formulas just to ignore all the 0 and
return the text value ie like below.

LRA
City Cap

Thanks.