PSMTQsecofr

Comments

Got me to where I needed to go, Thanks!

in How do I create a filter to show only the UPPERCASE records in a spreadsheet? Comment by PSMTQsecofr March 2021
Thanks. I'll give it a go and post my results.

in How do I create a filter to show only the UPPERCASE records in a spreadsheet? Comment by PSMTQsecofr March 2021
This is the Excel command to identify fields by case. =IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case",IF(EXACT(A2,PROPER(A2)),"Proper Case","Other")))

in How do I create a filter to show only the UPPERCASE records in a spreadsheet? Comment by PSMTQsecofr March 2021