Filter or Sort or Find cells that contain CAPS case

[cpw11]

I have a column (over 10,000 rows) with codes in it. I need to determine if the column contains one or more CAPITAL letters (vs all lowercase).

I consider myself fairly proficient in Excel, but I can not find any way to filter, sort, or fine (eg: IFNUMBER) cells that contain CAPS.

Note that the case sensitive sort does not work because I need to have a group of all cells that contain CAPS and that's not how the case sensitive sort works.

I'd appreciate any help on this!!

 

[wigi]

What is the output you desire?

Either a yes (contains caps) or no (does not contain caps); or do you want a list of cells that contain caps?

 

[cpw11]

The first is exactly what I'm looking for..."Yes" if contains caps and "No" if it does not contain caps. Are you able to be my hero?

 

[wigi]

Hi

Use

=MIN(--EXACT(A1:A25,LOWER(A1:A25)))=0

and confirm with Ctrl-Shift-Enter.

Change that 25 accordingly.

Wigi

 

[cpw11]

You just rocked my world. Thank you!

 

[mkomko]

can you help me? i dont know anything about excel... i have a list of names.
they are all in column A. some names are Leading Caps... and some are ALL CAPS.
is there a way to select all the ALL CAPS names and cut them out and put them in another column?

 

[NeonRedSharpie]

You'll need a helper column (probably) to do this.

Assuming your data is in column A starting at row2, add in a column somewhere and type the formula:

=EXACT(A2,UPPER(A2))

This will return true if all letter are in uppercase and false if they are not.

 

[mkomko]

sorry. i dont know what this means.

 

[jlukens]

This worked perfectly!!! Thank you! I needed to filter out all CAP names vrs Proper Case names and adding a column and using your formula added True or False to that column - then I filtered on all the Trues!! Perfect!! Thank you again!