Please HELP! Custom Sort List

Originally Posted by Jwildcat

I seem to be stumped. It seems you are trying to turn the text into a number which we can sort by number.

Is there another way to rewrite the custom sort list so it will sort the way I want it to?

What my formula did is strip the "Text " part away, to be left only with letters or numbers, then to determine the character code of that letter or number

Where A = 65 by default, B = 66. But 1 = 49, 2 = 50, so if it was a number and not a letter, I am adding 122 (which is the code for lowercase "z") to the characters code value, to make sure letters are always LOWER code values than numbers

Resulting in 1 = 171, 2 = 172, and so on, while
A = 65, B = 66

So they will sort by Letters, then Numbers

Looks like newdoverman also came up with a similar angle of attack, looks like it has the same disadvantage as mine though, multiple digits won't sort


I don't really have any experience with the custom sort lists unfortunately, I'm sure someone will be by though!