you can use an @mid function to "strip off" the first 6
numeric characters and put into a new column, sort on this
formula with a secondary sort on the alphanumeric part
number to order the alpha numbers.


-----Original Message-----
I am trying to sort a spreadsheet which has part numbers
as the main
description (ie: 500111, 500123, 500111A, 500111B,
500123A ...) I want the
sort option to sort the part number column with it's
associated data in
numerical order including the letters (ie: 500111,
500111A, 500111B, 500123,
500123A ... )
Anyone know how I can achieve this goal?
.