Sort by end letter?

**brotherwo** · 01-21-2011, 02:52 PM

I have a column with part numbers and some part numbers have an R at the end. My goal is try to sort all these 'R' part numbers but simply sorting goes by number first...

For example...

744491R
740011
739002
738790
738491
738491R
744491

I want...
744491R
738491R...then the rest

Thanks!

**NBVC** · 01-21-2011, 03:00 PM

Are you sorting in Descending order... if so, it seems to work with the R parts on top in descending order.

**brotherwo** · 01-21-2011, 03:18 PM

Originally Posted by NBVC

Are you sorting in Descending order... if so, it seems to work with the R parts on top in descending order.

well its actually more complicated with some products starting with Letters or Words

**NBVC** · 01-21-2011, 03:27 PM

Can you give a big sampling and show the expected order including some of the other possible combinations?

**brotherwo** · 03-03-2011, 05:32 PM

here is an example of what I am trying to do... I want all # ending in F by each other, when I sort they dont as the excel workbook shows

Thanks!

**NBVC** · 03-03-2011, 05:42 PM

Is this indicative of all your records? I.e. is it only the -F endings you want grouped separately?

if so, then in a helper column enter: =--(RIGHT(A2,2)="-F") copied down

Then sort by this column first, then the main column.