(Reply given to OP with attachment)

... Ah, I see. You want to have it sort in this manner at one go. Ok, I tried
revising the formula in col I in Sheet1 (Col I is the helper criteria col
here) to have pure alphas in col E (those w/o any numbers) come first (i.e.
assign these guys with large negative numbers), followed by alphanumerics
(those with a number at the "right" end) in descending order.

So the revised formula in I2 (in Sheet1) is:

=IF(E2="","",IF(ISNUMBER(RIGHT(E2,1)+0),10^10-(RIGHT(E2,1)+ROW()),CODE(RIGHT
(E2,1))-10^10+ROW()))

and I2 is then copied down, as before

With the above implemented in Sheet1, it seems to return the sorted order
that you want in either Sheet2 or 4

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----