Hi All
I have racked my brains on how to sort cells by Upper and Lower case words
Eg: ANT, Bird, Cat, DOG, Eagle

When i sort the cells i want the results to be either all Upper case words forst and then Lower case words, or vice vera.

ANT
DOG
Bird
Cat
Eagle

Hope this makes sense!