Sorting Issue

Try:

Please Login or Register  to view this content.

Confirmed with Ctrl-shift-enter.
It marks $P$418:$P$517 where is occupied with Text or number, then extract them.

Try the following modification: =IFERROR(INDEX($P$418:$P$517,SMALL(IF($P$418:$P$517<>"",ROW($P$418:P418)-MIN(ROW($P$418:$P$517))+1),""),ROW(1:1)),"")
Remember to activate by simultaneously pressing the Ctrl, Shift and Enter keys.
If this doesn't do what you want then it may help if you utilize the instructions in the banner at the top of the page and upload a sample workbook.
Let us know if you have any questions.

This proposal employs four helper columns (T:W) which may be moved and/or hidden for aesthetic purposes.
Column T identifies alpha entries using: =IF(CODE(Q7)>=97,CODE(Q7))
Column U identifies alphanumeric entries using: =IF(AND(ISNUMBER(VALUE(LEFT(Q7))),CODE(RIGHT(Q7))>=97),SUM(122,VALUE(LEFT(Q7,LEN(Q7)-1))*CODE(RIGHT(Q7))-96))
Column V lists unsorted values using: =SUM(Q7,T7:U7)
Column W lists sorted values using: =SMALL(V$7:V$36,ROWS(A$1:A1))
The formula for column S is: =INDEX(Q$7:Q$36,MATCH(W7,V$7:V$36,0))
Let us know if you have any questions.

You're Welcome and thank you for the feedback. If this works for your actual data, please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

As to the example at the top, modify the formula in column U so that it reads: =IF(AND(ISNUMBER(VALUE(LEFT(Q7))),CODE(RIGHT(Q7))>=97),SUM(VALUE(LEFT(Q7,LEN(Q7)-1)),0.01*(CODE(RIGHT(Q7))-96)))
looking at the example on the bottom, it will possibly need to be solved separately. I'll address that proposed solution in another post.
Let us know if you have any questions.

As to the example on the bottom:
Modify the formula in column T to read: =IF(Q7="","",IF(CODE(LEFT(Q7))>=97,SUM(CODE(LEFT(Q7)),IFERROR(VALUE(RIGHT(Q7,LEN(Q7)-1))*0.01,0))))
The formula in column V to read: =IF(Q7="","",SUM(T7:U7))
The formulas in columns S and U will also need to be prefixed using: =IF(Q7="","",...
Let us know if you have any questions.