How do I filter cells based on character case in Excel

R

Rarebreeed

Hello,

I have a column of user passwords, some in all Uppercases, some in all
smallcases while others in mixed cases; Please how do i filter based on cases?
 
R

Rick Rothstein

Use this formula in a helper column and filter that helper column...

=IF(EXACT(A1,UPPER(A1)),"Upper",IF(EXACT(A1,LOWER(A1)),"Lower","Mixed"))
 
R

Rarebreeed

Hey Rick,

Exactly what i needed.
Thanks a zillion!
I really appreciate, Thanks.
 

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

Formating bolded text exclusively. 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Lower-Case Characters 2
Excel does not accept text format! 0
filtering to separate upper & lower case 5
Can't save my Office documents (after computer rebuild and reauthorization) 0
WORD VBA Search and switch to advanced ... 1
Automation of scanned file storage based on content 0

Top