i am not using macros or VBA...only the EXCEL formulas.
"Ron Rosenfeld" wrote in message
...
On Sun, 24 Sep 2006 17:39:01 -0700, F. Lawrence Kulchar
wrote:

How can I test a text value in a cell when CAPITALIZATION DOES NOT EQUAL
LOWER CASE???

In other words, "MIAMI" and "Miami" is NOT a match.

Thanks,

FLKulchar

In VBA, with the default Option Compare Binary, you can use the "Like"
operator.

In Excel, you can use the EXACT worksheet function.


--ron