| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I filter cells based on character case in Excel
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I filter cells based on character case in Excel
Hey Rick,
Exactly what i needed. Thanks a zillion! I really appreciate, Thanks. "Rick Rothstein" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Filter Character Size | Excel Discussion (Misc queries) | |||
| Need character for custom format to force upper case! | Excel Discussion (Misc queries) | |||
| How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
| How to change character to lower case except the first letter? | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Linear Mode
