Hard to Sort Sorting

  • Thread starter Thread starter ysuswim
  • Start date Start date
Y

ysuswim

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.
 
You could add an extra column and just elminate that character:

=left(a1,3)&mid(a1,5,len(a1))
drag down and sort by that helper column
 
=CODE(MID(A1,9,9)) in a helper column

Sort on the helper column


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting 2
sorting multiple sheets with one button? 1
Adding more sort fields to the SORT Dialog Box 3
Automatic Data Sort? 9
Excel Sorting Order 3
Merging Cells and Sorting 1
Sorting Starting at Second Character 5
Sorting Columns by number of characters 1

Back
Top