Microsoft Office Tutorials and References

In Depth Information

**Using EXACT to Test Case**

Tip

An alternative solution is to format column A with the custom format

of "@*.". This shows the text in the cell and follows it with a series

of periods, enough to fill the current width of the column.

Using

Using
EXACT

to Test Case

For the most part, Excel isn
’
t concerned about case. To Excel, ABC and abc

are the same thing. In
Figure 11.64
, cells A1 and B1 contain the same letters,

but the capitalization is different.

EXACT
to Test Case

Figure 11.64.

Figure 11.64.
Excel usually overlooks differences in capitalization when

Excel usually overlooks differences in capitalization when

deciding whether two values are equal. You can use

deciding whether two values are equal. You can use EXACT

EXACT to find out

to find out

whether they are equal and the same case.

The formula in cell C1 tests whether these values are equal. In the rules

of Excel, AbC and ABC are equivalent. The formula in cell C1 indicates that

the values are equal. To some people, these two text cells might not be equi-

valent. If you work in a store that sells the big plastic letters that go on

theater marquees, your order for 20 letter afigures should not be filled with

20 letter Afigures.

Excel forces you to use the EXACT function to compare these two cells to

learn that they are not exactly the same.

Syntax

=EXACT(text1,text2)