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
To do this task, use the EXACT function.
Note: EXACT is case-sensitive but ignores formatting differences.
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. Excel inserts curly brackets at the beginning and end of the formula. 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.
Check if part of a cell matches specific text
Note: The FIND function is case-sensitive.
The formula in the above screenshot uses the following arguments.
Formula to check for text
search_for: What you want to check for.
to_search: The cell that contains the text that you want to check.