sorting by last char

  • Thread starter Thread starter JohnW
  • Start date Start date
J

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
 
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
 
Back
Top