If your alpha numeric part number is always 6digits number and the rest
alphabet(s) then
insert a column next to the part list and trype

=--(left(a1,6)) and copy it down
Now sort based on this new column selecting all the columns




"jem" wrote in 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?