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.

Hi and welcome
Try the following:
say your data is in col A
In B1 enter =RIGHT(A1,LEN(A1)-4)+0 and double click the handle in the right lower corner to extend the formula
Then select data from col A and B and sort by Col B ( you can hide this column if needed)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post