One way would be to use a helper column. For example, in the cell next to
BA101A, use the following formula to determine the last letter.

=right(A1,1)

Copy this formula down as needed. Then you can sort by this column.

HTH,
Paul

"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?

Thanks