In Excel, how do I sort a column by the LAST digit of the data?
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!
|