ExcelBanter - Check for CAPS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Check for CAPS (https://www.excelbanter.com/excel-worksheet-functions/235020-check-caps.html)

Heidi

Check for CAPS

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?

RonaldoOneNil

Check for CAPS

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?

Heidi

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?

Heidi

Check for CAPS

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?

All times are GMT +1. The time now is 07:17 PM.