Right to Left sorting without changing language settings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of approx 9,000 codes and would like to sort based on specific
criteria the most helpful would be to sort from right to left on the text in
the column so all cells ending with -00, -01, -02 etc would be grouped in
order. Is this possible without loading service pack 3 as it still has too
many bugs for my comfort, or without changing the language settings to Arabic
or Hebrew...?
 
That's a great idea! So, make another column and you can put just the right
two characters of each of the original cells into it with formula:
=right(c1,2). I don't know if c1 is really the right cell reference in your
file, but just put the cell address that has the original data in that spot
of the formula. Then, you can sort by the new column.
 
Back
Top