I have a list of piece-marks that gets sorted wrong:
321A1
321A10
321A11
321A2
321A3
321A4
321A5
321A6
321A7
321A8
321A9
Notice that the 321A10 and 321A11 are not sorted after the 321A9. Is there a macro or setting that can be used to fix this sort. Excel does not seem to consider the last two numbers as a single whole number but sorts according to sequential alphanumeric values, instead. I cannot change the data, either. This would involve thousands of individual edits and it is not feasible. Do you have a macro that would consider the 321A and the ending number/s separately. Perhaps it could sort according to the first section, being an alphanumeric and then the ending number can be treated as a single whole number so that 321A10 would sort after 321A9.
Thank you.