Skip to main content

Find Data in Cell

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)