You are the bomb! This is perfect. Thanks much!

"RonaldoOneNil" wrote:

If all your names are in column A then put this in column B and copy down. It
will show True for the capitals and false for the others
=EXACT(A1,UPPER(A1))

"Heidi" wrote:

I have a list of names in this format:

Johnson,Dave
Smith,Karen
MENDOZA,JUAN

I need to run a check and identify all the cells where the name is in all
CAPS.

Can someone help?