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?

Thanks