IREALLYambatman
Board Regular
- Joined
- Aug 31, 2016
- Messages
- 63
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 :
<tbody>
</tbody>
And Excel does this:
<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?
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?
Last edited: