Super Advanced Search Algorithm Annoyance

[IREALLYambatman]

Sooo.. I have a ton of data and I need it arranged all by one Row... And using Regex, and custom order, and ascending.. I'm 90% of the way there, unfortunately I'm now kinda stuck, I need to sort like this :

AAA

AAA x2

AAA x5

AAA x10

<tbody>
</tbody>

And Excel does this:

AAA

AAA x10

AAA x2

AAA x5

<tbody>
</tbody>

So Excel Looks at each charecter and says that x10 should come before X2 because you well, it fails to understand that 10 < 2.

What can I do to fix this? I have all the rest done, all the AAA's and BBB's are in order, it's just the x2 or x5 or x20 or xwhatever that it fails to realize that is a number.. help?

 

[Yongle]

Classing sorting "numbers as text" issue
- easily solved if you make numbers consistent
- insert leading zeros
- with your example increase all numbers to 2 digits
- if largest number is 3 digits then make EVERY number 3 digits


So instead of

AAA

AAA x2

AAA x5

AAA x10

<tbody>
</tbody>

Amend data like this and the problem goes away

AAA

AAA x02

AAA x05

AAA x10

<tbody>
</tbody>

 

[IREALLYambatman]

Classing sorting "numbers as text" issue
- easily solved if you make numbers consistent
- insert leading zeros
- with your example increase all numbers to 2 digits
- if largest number is 3 digits then make EVERY number 3 digits


So instead of

AAA

AAA x2

AAA x5

AAA x10

<tbody>
</tbody>

Amend data like this and the problem goes away

AAA

AAA x02

AAA x05

AAA x10

<tbody>
</tbody>

thanks dude, you rock!