Check if a Cell Contains a Substring

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.