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.
No comments:
Post a Comment