Sorting from right to left

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

L
Wed Jan 12 18:07:31 CST 2005

Hi Rocky,

Perhaps you can do this. In the column next to your data, B1, enter
=Right(A1,3) and fill down to the bottom of your list in column A. Now sort
by column B.

HTH
Regards,
Howard

"Rocky" <rockylamATyahooDOTcom> wrote in message
news:%23gox0KQ%23EHA.2596@tk2msftngp13.phx.gbl...
> 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
Thu Jan 13 14:44:37 CST 2005

Can anybody show me if this is possible.

Thanks

Rocky


"Rocky" <rockylamATyahooDOTcom> wrote in message
news:%23gox0KQ%23EHA.2596@tk2msftngp13.phx.gbl...
> 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
>

L
Thu Jan 13 17:55:47 CST 2005

Hi Rocky,

Essentially, the RIGHT function pulls the last three characters from the
data in column A into column B. Then you select both columns by starting in
B1. Both columns will be selected and B1 will be the active cell, the one
that is still white while the others are blue. Do the sort and dismiss the
column B.

If you want send me a workbook with some similar data and I will see if I
can set it up to do what you want.

lhkittle@comcast.net

Howard

"Rocky" <rockylamATyahooDOTcom> wrote in message
news:%23gox0KQ%23EHA.2596@tk2msftngp13.phx.gbl...
> 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
>

L
Thu Jan 13 21:22:22 CST 2005

Hi Rocky,

Essentially, the RIGHT function pulls the last three characters from the
data in column A into column B. Then you select both columns by starting in
B1. Both columns will be selected and B1 will be the active cell, the one
that is still white while the others are blue. Do the sort and dismiss the
column B.

If you want send me a workbook with some similar data and I will see if I
can set it up to do what you want.

lhkittle@comcast.net

Howard

"Rocky" <rockylamATyahooDOTcom> wrote in message
news:%23gox0KQ%23EHA.2596@tk2msftngp13.phx.gbl...
> 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
Sat Jan 15 08:54:00 CST 2005

Thanks, I got it to work by type the forumla on another worksheet and copy
the formula back to the original worksheet.

Rocky


"L. Howard Kittle" <lhkittle@comcast.net> wrote in message
news:AKudnRH6RIpyp3rcRVn-iA@comcast.com...
> Hi Rocky,
>
> Essentially, the RIGHT function pulls the last three characters from the
> data in column A into column B. Then you select both columns by starting
> in
> B1. Both columns will be selected and B1 will be the active cell, the one
> that is still white while the others are blue. Do the sort and dismiss
> the
> column B.
>
> If you want send me a workbook with some similar data and I will see if I
> can set it up to do what you want.
>
> lhkittle@comcast.net
>
> Howard
>
> "Rocky" <rockylamATyahooDOTcom> wrote in message
> news:%23gox0KQ%23EHA.2596@tk2msftngp13.phx.gbl...
>> 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
>>
>
>