Sort data from Left to Right

R

Rocky

Is there any way to sort the right the format from "Right to Left" instead
of
"Left to Right".

123456ABC
123456CBC
123456BBC

I like to see that I can sort the last three characters.

Thanks

Rocky
 
M

Myrna Larson

No, there isn't. You can use a "helper" column that contains the last 3
characters and sort on that. The formula would be =RIGHT(A2,3), copied down.
If you sort ascending on that column, you'll get ABC, BBC, then CBC. I presume
that's what you want?

If you want ABC,CBB,then CBC, (sorted as though the last 3 characters were
reversed to CBA, CBC, and CBB) you could separate the 3 characters into 3
separate columns, or create a formula like

=MID(A2,9,1)&MID(A2,8,1)&MID(A2,7,1)
 
R

Rocky

I have tried your suggestion but is doesn't work for me. I am the sample
file for you to check it out. If possible you insert the formuala. I check
and follow.

Thanks

Rocky
 
R

Rocky

I type this on the cell. =RIGHT=(A2,3) and copied down and all I get is the
=RIGHT=(A2,3) down the column.

I am using Excel 2003 and there anything I did wrong.

Thanks

Rocky
 
B

Bill Sharpe

Rocky
You've got an extra = in your formula. It should be =RIGHT(A2,3)

Bill
"Rocky" <rockylamATyahooDOTcom> wrote in message
I type this on the cell. =RIGHT=(A2,3) and copied down and all I get is
the
=RIGHT=(A2,3) down the column.

I am using Excel 2003 and there anything I did wrong.

Thanks

Rocky
 
Top