Microsoft Office Tutorials and References
In Depth Information
Using EXACT to Test Case
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.
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. 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.