Check if a cell contains text (case-sensitive)

Let's say you want to find text that begins with a standard company prefix, such as ID_ or EMP-, and this text must be in uppercase letters. There are several ways to check if a cell contains text and the case of the text matters to you.

Compare one cell to another cell

Compare one value to a list of values

Note: The formula in the example must be entered as an array formula. After you enter the formula. press F2, and then press CTRL+SHIFT+ENTER. If the formula is not entered as an array formula, the error #VALUE! is returned. For more information on array formulas, see Guidelines and examples of array formulas.