Re: sorting a case sensative list alphabetically
Lowercase letters have got different ASCII codes that uppercase ones...
Uppercase is ASCII#65-90 whereas lowercase is ASCII#97-122
It should be relatively easy to write a macro that sorts your list into 2 lists (uppercase and lowercase)... and then you can do an alphabetical sort on both list in Excel.
Unfortunately, my programming skills are too poor to write such macro.
There might be an easier way to do it...
|