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

Word doc keeps changing to ALL CAPS 0
Dealing with the error: unable to filter on excel hc home school 0
All CAPS to Caps 2
Delete all data after a symbol in a field 0
Parsing full name into salutation, First, middle, last, Suffix 1
Help creating a search form in Access XP 0
Init Caps 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top