Microsoft Excel Functions & Formulas

Use the EXACT function to perform a

case-sensitive search

Usually Excel doesn’t differentiate between uppercase and lower-

case letters. To search for a string that has the same case, use the

EXACT function. The search string is entered in cell B1. With the

support of conditional formatting, all cells within a specified range

will be formatted if they contain the exact search string.

4

To perform a case-sensitive search on text:

1. In a worksheet, enter a variety of values in cells A3:E13,

being sure to use “Excel” in several cells (or copy the val-

ues in Figure 10-17).

2. In cell B1 enter Excel.

3. Select cells A3:E13.

4. On the Format menu, click Conditional ...