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

--
with kind regards

Spike