PSMTQsecofr Member

• Activity
• Discussions1
• Comments

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