Capital Letters versus Not

[Guest]

I wish to compare a list of cells as follows:

A B

1 Abc ABC
2 MIAMI Miami
3 DCFG Dcfg

etc.

One cell is ALL capitalized...the other...only the first letter is
capitalized.

Please give formula to differenciate the two.

Thank you.

FLKulchar

 

[Andrew Taylor]

=EXACT(A1,B1)
and so on..

 

[FLKulchar]

Thank you

=EXACT(A1,B1)
and so on..