Developer Forum

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

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

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

You can get the last character by using a blank column and entering
this formula:

=RIGHT(A1,1)

assuming your data is in A1. Copy this formula down the column. Include
this column in your sort area and use this column as the key field to
sort on (plus the other field).

Hope this helps.

Pete

In an adjacent column, add

=RIGHT(A1,1)

copy down, and sort by that column

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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