"Spencer" wrote in message
...
I need to sort a column of items by the last letter in the item number:

BA101A
BA102C
ST101A

How can I do this? Do I need to split the cell and then sort it? If so how
do I do that?

If you use a helper column =RIGHT(A1) you can sort by that.
--
David Biddulph