Insert a helper column to the right of your data and parse off the last
character of the item number.

So if the item number is in column C starting at row 2, enter the formula:

=RIGHT(C2,1)

Copy it down the column and use this as the sort column
--
Kevin Backmann


"Spencer" wrote:

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