Hi there, new here. :D
I've read through some of the other alphanumeric sorting posts but nothing seemed to help with my problem. I have something like this:
a1402
a1a21
a1235
z124
x1x2
x11a2
Not only are the letters and numbers mixed, but also of different lengths.
What it should sort as is:
a1a21
a1235
a1402
x1x2
x11a2
z124
But what it is doing is this:
a1235
a1402
a1a21
x11a2
x1x2
z124
aia should be BEFORE a12 and a14 etc...
I can make the cells all the same length by inserting numbers at the end but I can't get it to sort this right. Assuming I have hundreds more rows in my project so it's not so simple as manually reorganizing, is there anything I can do? Thnks!
Bookmarks