Thanks for taking the time to read my question.

I have a column of formulas like this:

=if(B1="","",B1)

This works fine, but I want to use this column as the row source for a value
list from Data - Validation. There is a check box there that says Exclude
Blanks. "" is a zero length string, not blank, so my value lists are long and
empty.

How can I make my formula return nothing instead of a zero length string?

Thanks,

Brad