Check for CAPS

H

Heidi

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?
 
R

RonaldoOneNil

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

All CAPS to Caps 2
Excel Split column data 0
Init Caps 2
Caps Lock vs Lower Case 5
Formating - Date as Month In All Caps 5
Two Level Search 1
Returning the most duplicated item 2
Capitalizing Text 12

Top