Sort by Upper case

[xenios]

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.

 

[dave3009]

Not working in what way? It would be useful to see an example and an explanation of why you believe it's not working.

 

[xenios]

Not working in what way? It would be useful to see an example and an explanation of why you believe it's not working.

I'm getting the attached error. I have tried to change " to ' , but still no luck.

 

[Fluff]

Do you normally use commas as the separator in formula, or do you need to use semi-colons?

 

[xenios]

Do you normally use commas as the separator in formula, or do you need to use semi-colons?

Don't use Excel very often, but yes, this was the case, thank you )

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Fluff]

Glad it's sorted & thanks for the feedback.