Skip to main content

Find Data in Cell

This document is in development

SEARCH finds "text value" in cell A1.

IF result of SEARCH is that the data is found, result returns TRUE. Else, FALSE.

=IF(SEARCH("text value",A1,1),TRUE,FALSE)