How do I filter cells based on character case in Excel

  • Thread starter Thread starter Rarebreeed
  • Start date Start date
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?
 
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"))
 
Back
Top