Sorting in ASCII order

[ddempsey]

Hello Mr. Excel - thanks for all of your help,

I need to sort a column in ASCII order, because I need to send the values in that order to a different piece of software (the software has a bug that makes this necessary).

Normally, when you sort, you would get something like this:
Cat
CHICKEN
DOG
Eagle
ELEPHANT

I need something like this, where the Capital letters come before the small letters, because that is how it is in ASCII:

CHICKEN
Cat
DOG
ELEPHANT
Eagle

I have searched everywhere, with no success. Is this possible?

 

[schielrn]

Welcome to the Board!

See if this post is of any assistance:

http://www.mrexcel.com/forum/showthread.php?t=14687