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!

How many variations of words are there before the character to sort by?

Or, is it always two words? Is there a special character at the end before the number? (for example, "This is the data: 2")