Sorting from right to left

  • Thread starter Thread starter Rocky
  • Start date Start date
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
 
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
 
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.

(e-mail address removed)

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

(e-mail address removed)

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

Rocky
 
Back
Top