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.