Right to Left sorting without changing language settings

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...?
 
G

Guest

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.
 

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

Top