排序 字母+数字+符號 (10734)

C3{=INDEX(A:A,RIGHT(SMALL(CODE(LEFT(A$3:A$12))*10^9+SUBSTITUTE(MID(A$3:A$12,2,9),"-",".")*10^7+ROW($3:$12),ROW(A1)),2))

G3{=INDEX(E:E,RIGHT(SMALL(SUBSTITUTE(E$3:E$10,"-",".")*10^7+ROW($3:$10),ROW(A1)),2))