Sorting question
 

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 :)


--
blueglass74
------------------------------------------------------------------------
blueglass74's Profile: http://www.excelforum.com/member.php...o&userid=10812
View this thread: http://www.excelforum.com/showthread...hreadid=515541

Sorting question
 

You might want to add a helper column in it with the CODE() function in it
and sort on that.

"blueglass74"
wrote in message
...

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 :)


--
blueglass74
------------------------------------------------------------------------
blueglass74's Profile:
http://www.excelforum.com/member.php...o&userid=10812
View this thread: http://www.excelforum.com/showthread...hreadid=515541

Sorting question
 

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.



blueglass74 wrote:

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 :)

--
blueglass74
------------------------------------------------------------------------
blueglass74's Profile: http://www.excelforum.com/member.php...o&userid=10812
View this thread: http://www.excelforum.com/showthread...hreadid=515541

--

Dave Peterson