Thread: How do I filter cells based on character case in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default How do I filter cells based on character case in Excel
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"))

--
Rick (MVP - Excel)



"Rarebreeed" wrote in message
...
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?


Reply With QuoteReply With Quote