Try

=if(cell("type",B2)="l",then,else)

"l" is lower case L standing for "Label". See the help for this function
describing other data "type".

Regards

Phil

"roy.okinawa" wrote:

> Is there a way to use a wild card character to search for all text?
> Something like this:
> =IF(A2="","",IF(ISNUMBER(SEARCH("All text",B2)),A2+ROW()/10^10,""))
>
> Column A has a date. Column B has text. I enter a date in C1 and all the
> text in Column B is populated starting at C2 and carried on down the column
> for all text matching the entered date.