View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ysuswim ysuswim is offline
external usenet poster
 
Posts: 1
Default Hard to Sort Sorting

Does any know if you can sort the following by skipping the 4th letter:

RPE3-063Y11/12060E5
RPE3-063C11/12060E5
RPE3-063H11/12060E5
RPE4-063Y11/12060E5
RPE4-063C11/12060E5
RPE4-063H11/12060E5


I would like to know if I can get them to automatically sort into the
following way.

RPE3-063C11/12060E5
RPE4-063C11/12060E5
RPE3-063H11/12060E5
RPE4-063H11/12060E5
RPE3-063Y11/12060E5
RPE4-063Y11/12060E5

For us the 4 item is a series number and we have parts that have been
updated and need to be merged in our system. I thought that this would be an
easier way to sort through the items.