Sort Data Using the Last Character As the Primary Sort Character

[dnamertz]

I have data that I want to sort and the column I want to sort by is a list of part numbers. Some of these part numbers end with an "s" and I want to group all those part numbers together. Since the "s" is at the end of those part numbers, I don't know how to sort those. Can I set by the last character in a cell?

Or, can I reverse the contents in a cell so that the "s" would be at the beginning?

[alansidman]

A couple of questions. Are the part numbers all the same length? Do all the part numbers have an alpha character at the end?

Can you provide a sample of what the part numbers may look like?

[FDibbins]

perhaps use a helper column?
=if(right(A1,1)="S",0,1)
then sort on the helper 1st, and then by whatever else you sorted?

[dnamertz]

perhaps use a helper column?
=if(right(A1,1)="S",0,1)
then sort on the helper 1st, and then by whatever else you sorted?

That worked, thanks.

alansidman, to answer your question all the part numbers are not the same length

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.