Check If A Cell Contains Specific Text

less than 1 minute read

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:

check-if-a-cell-contains-specific-text-7144189

Tags: text

Categories: formulas

Updated: May 03, 2021

Twitter Facebook LinkedIn

Leave a Comment