Check for CAPS
You are the bomb!!! Thanks much. It was perfect.
"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?
|