xenios
Board Regular
- Joined
- Sep 4, 2020
- Messages
- 91
- Office Version
- 2016
- Platform
- Windows
Dear All.
I'm trying to use the following formula to sort the text in column by Upper case (all text in upper case). But it's not working. Any ideas?
=IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case",IF(EXACT(A2,PROPER(A2)),"Proper Case","Other")))
Thank you.
I'm trying to use the following formula to sort the text in column by Upper case (all text in upper case). But it's not working. Any ideas?
=IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case",IF(EXACT(A2,PROPER(A2)),"Proper Case","Other")))
Thank you.