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 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.

Get the file.