In Excel, is it possible to sort alphanumerics from a-1, a-2, a-3...a-123 instead of a-1, a-10, a-100, a-11?
Sorting via oldest to newest or via A-Z, definitely won't give me the result I want. I've tried formatting the cells as number, but it didn't help.
I'm stuck.
3 Answers
User @fixer1234 is right, you probably want to use string functions. Here is one way to do that.
Step 1
[Updated]
In the "Numbers" column, highlight the range, then split the text at the hyphen: do...
Data > Text to Columns > Delimited > Next > Other: - > Finish
Notice you need a hyphen (-) in the Other: textbox. And make sure that the adjacent column (to the right) is empty before you do this, so that you don't overwrite important data.
You could also use this function to do extract the number from column A:
=RIGHT(A2,LEN(A2)-SEARCH("-",A2))
