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

Spike


"Ryan H" wrote:

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.
--
Cheers,
Ryan


"Spike" wrote:

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