Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about sorting in protected worksheet | Excel Worksheet Functions | |||
SORTING question | New Users to Excel | |||
Question on sorting dates | Excel Discussion (Misc queries) | |||
sorting question | Excel Worksheet Functions | |||
sorting question | Excel Discussion (Misc queries) |