sorting by last char

[JohnW]

Hello,
I have a table where in a column there is something like:
1a, 1b, 1c, 2a, 2b, 2c and so on

I wish to sort by the last char to look like:
1a
2a
1b
2b
1c
2c

I tried Tools/Options/Custom List using *a,*b,*c to no avail.

Any ideas?

Thanks

 

[Pete_UK]

You can extract that last character into a helper column using:

=RIGHT(A1)

and copying down as needed. Then you should include the helper column
within the data range when you sort, and sort on the helper first,
followed by your other column. Delete the helper column when you've
finished with it.

Hope this helps.

Pete

 

[JohnW]

Thanks for that, did the trick.

 

[Pete_UK]

You're welcome, John - thanks for feeding back.

Pete