Sort data from Left to Right
 

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

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)



On Thu, 13 Jan 2005 13:54:31 -0800, "Rocky" <rockylamATyahooDOTcom wrote:

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

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



"Myrna Larson" wrote in message
...
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)



On Thu, 13 Jan 2005 13:54:31 -0800, "Rocky" <rockylamATyahooDOTcom wrote:

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

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


"Myrna Larson" wrote in message
...
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)



On Thu, 13 Jan 2005 13:54:31 -0800, "Rocky" <rockylamATyahooDOTcom wrote:

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

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


"Myrna Larson" wrote in message
...
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)



On Thu, 13 Jan 2005 13:54:31 -0800, "Rocky" <rockylamATyahooDOTcom
wrote:

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