Right to Left sorting without changing language settings
 

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

Right to Left sorting without changing language settings
 

I'd try to put that "suffix" in its own column and then sort by that column.

Natemoney2 wrote:

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

--

Dave Peterson

Right to Left sorting without changing language settings
 

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.

"Dave Peterson" wrote:

I'd try to put that "suffix" in its own column and then sort by that column.

Natemoney2 wrote:

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

--

Dave Peterson