In Excel, I would like to perform an alphanumeric sort of the following data and have the results be in the same sort order:
A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21, A22, A23, A24, A25.
Instead of the traditional left to right, character by character resulting in the following sort order:
A1, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A2, A20, A21, A22, A23, A24, A25, A3, A4, A5, A6, A7, A8, A9.
Any help I could get on this issue would be GREATLY appreciated.
Thanks in advance!
A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21, A22, A23, A24, A25.
Instead of the traditional left to right, character by character resulting in the following sort order:
A1, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A2, A20, A21, A22, A23, A24, A25, A3, A4, A5, A6, A7, A8, A9.
Any help I could get on this issue would be GREATLY appreciated.
Thanks in advance!