Check If A Cell Contains Specific Text

less than 1 minute read

How it Works Using SEARCH and ISNUMBER

When you need to check if a cell contains specific text (or string) we need to combing the SEARCH and ISNUMBER functions. The SEARCH function will give us the starting position of the text you’re trying to find, when that is wrapped in the ISNUMBER function we will end up with a TRUE or FALSE.

Generic formula

' syntax
=ISNUMBER(SEARCH(text_to_search_for, within_text))

' if cell contains example
=IF(ISNUMBER(SEARCH(text_to_search_for, within_text)), "Yes", "No")

In the example shown, the formula in D5 is:

=ISNUMBER(SEARCH(C5,B5))

Check-if-a-cell-contains-specific-text