Check if a Cell Contains a Substring in Excel

Case insensitive

In order to check whether a cell contains a substring in a text, use the following formula.

The following formula will return TRUE if a substring is inside the text. This formula is case-insensitive.

Both of these examples will return TRUE.

Case sensitive

If you want to create a formula that is case-sensitive, you have to use the FIND function, instead of SEARCH.

Now, the first example returns TRUE and the second one returns FALSE.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.