Finding Cells that are all Capitalized

[NZ Kiwi]

I’ve looked through the forum and can’t find anything that will help me find cells that have all the words in the cell all capitalized. I’m just looking for a formula I can put next to the cell in question that denotes it’s all caps. This will help me sort them.

Many Thanks

D

 

[Scott Huish]

Assuming your values starting in A1:

=EXACT(A1,UPPER(A1))

Copy down.

 

[NZ Kiwi]

Excellent, that did the trick. Thanks HP

D