Is there a way I can sort numbers such that if I have a letter suffix (ie; 2A, 3B, etc), they are sorted after the original number, ie; 2A between 2 and 3 then 3B between 3 and 4?I am in need of help exactly like this, but none of the answers so far are working for me. I have racecar #'s that I need to sort by, example 1, 1A, 2, 3, 4, 4V, 7, 8, 9, 9D, 10, 20, 30, 40, 40H, 42, 45, 45b, 60, 70, 80, 123, 132, 132A, 132C, etc. Is
Thanks.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 285 |
Nodes: | 16 (2 / 14) |
Uptime: | 75:16:02 |
Calls: | 6,489 |
Calls today: | 2 |
Files: | 12,096 |
Messages: | 5,276,078 |