| Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers. Check if a cell contains text (case-sensitive)
Applies to: Microsoft Office Excel 2003
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. What do you want to do?Compare one cell to another cell Compare one value to a list of values Check if part of a cell matches specific text Compare one cell to another cellTo do this task, use the EXACT function. ExampleThe example may be easier to understand if you copy it to a blank worksheet.
Note EXACT is case-sensitive but ignores formatting differences. Function detailsCompare one value to a list of valuesTo do this task, use the EXACT and OR functions. ExampleThe example may be easier to understand if you copy it to a blank worksheet.
Note The formula in the example must be entered as an array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.). After copying the example to a blank worksheet, select each formula cell individually. Press F2, and then press CTRL+SHIFT+ENTER. If the formula is not entered as an array formula, the error #VALUE! is returned. Function detailsCheck if part of a cell matches specific textTo do this task, use the IF, FIND, and ISNUMBER functions. Note The FIND function is case-sensitive. ExampleThe example may be easier to understand if you copy it to a blank worksheet.
The formula above uses the following arguments. Formula to check for text
Function details |
Printer-Friendly Version
Show All
Hide All
search_for: What you want to check for.
to_search: The cell that contains the text that you want to check.
