Sorting problem

M

Marta

Hello,
I have a column with the following entries:
N127851R
N131772A
N141589A
N141589R
N145665T
N151486A
N157433A

I would like to sort by the last character. How do I do that?

Thanks,
Marta
 
K

Kevin B

Create a helper column to the right of your data and use the following
formula to extract the last character:

=RIGHT(B1,1)

Substitute the correct column and row in the example above with your column
& start row. Copy the function down to the last data row and use the helper
column as your sort column.
 
Top