Sort on last two digits of data

[Spike]

A sorting question.

I have a sheet of data A12:BC77. I would like to sort this on items in
column A. The problem is I need to order it by the last two digits of the
data in Column A. So say ZWE11 will come before AA77 and QW22 will come
before BB55 and so on. There is probably a simple answer but it is missing
me at the moment.

All I can think of is splitting out the last two digits into a new column
and sorting on that, then deleting that column once sorted but seems very
messy.

Any advice will be very gratefully received

 

[Per Jessen]

Hi Spike

If I had to write a macro for this task, it would work just as you
suggest to do manually.

Why not use column BD as helper column. Enter the formula below in
BD12 and copy it down to BD77.

=Right(A12,2)

Now select the entire table, sort on column BD, and hide the column
for future use. (You can sort on column BD even when it is hidden)

Hopes this helps.
....
Per

 

[Ryan H]

I would do what you said. Insert a column before Col. A. Then put this
formula in A12, "=RIGHT(B12, 2)". Copy the formula down to row 77. This
will put the last 2 characters of data from Col. B in Col. A. Then hide the
column. Now you can sort by Column A. This would be much easier than doing
it by code. Hope this helps! If so, let me know, click "YES" below.

 

[Spike]

Thank you, that is what i have done in code but thought there must be a
neater way of doing it