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.