Sorting question

B

blueglass74

I have a document with lower case words and upper case words. I need to
sort them so that all lower case words are together. How do I do this?
I do not know macros or codes so will need the longer explanation :)
 
D

Dave Peterson

Are these lists in a single column?

If yes, then I'd insert a helper column and use a formula like:
=IF(EXACT(A1,UPPER(A1)),"Upper",IF(EXACT(A1,LOWER(A1)),"Lower","Mixed"))
And drag down.

Then sort by this column.

But be aware that
1234
@#$%
will both return Upper.
 
Top