Insert a column and copy this formula all the way down
=right(a1,1)
Now sort using this column as the first sort criterion and the original
column as the second sort criterion.
"DougMash" wrote in message
...
I need to sort a column of data by the LAST digit of the data. We add a
letter to the end of our catalog numbers to denote "new" (ie 012345-N) or
"used" (12345-U), and I'd love to be able to sort by that last digit.
Thanks!
|