trying to remove a space

you know how if you type in a1 and it's longer than cell width it will spill over into b1? if b1 has a formula with the result being "" it won't spill over. what do use as the result for the formula in b1 that will not block a1 spilling over?

some of the results in a1 are shorter if b1 has anything shown. I just need b1 to not block a1 in cases where b1 needs to be blank and a1 is longer.

sorry about the wacky first post. both a1 and b1 have if statements yielding text results or no results to provide a printable menu that is easily customizable be salesman


a1 if(a24=1,"security plus gold preferred","resource")
b1. if(a24=1,""," platinum")

this is a very simple version, I just need the "" in b1 to not block last part of "security plus gold preferred" if a24 = 1

thank you,
Eddy Brown
uftring Nissan

thanks for looking. I think I will hit it a different way.