How do I sort a column by last character
 

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.

How do I sort a column by last character
 

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.

DPK_02 wrote:

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

How do I sort a column by last character
 

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

http://www.realezsites.com/bus/primi...e/products.php

Vaya con Dios,
Chuck, CABGx3



"DPK_02" wrote:

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.