ExcelBanter - Sorting problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sorting problem (https://www.excelbanter.com/excel-discussion-misc-queries/181675-sorting-problem.html)

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

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.
--
Kevin Backmann

"Marta" wrote:

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