How do I sort a column by last character

[DPK_02]

I am trying to sort a row based on the last character in a string of
characters or if reading right to left, I would be sorting by the first
character. Can someone tell me how to do this. Thanks.

 

[Dave Peterson]

You can add another column with a formula like:
=right(a2,1)
to get the rightmost character in A2
Then drag this formula down as far as you need.

And finally sort the entire range using this "helper" column as the primary key.

 

[CLR]

For unusual sorting criteria, I use Jim Cone's nifty commercial Add-in called
SpecialSort. It's available at

http://www.realezsites.com/bus/primitivesoftware/products.php

Vaya con Dios,
Chuck, CABGx3