拆一數字一字母 (10407)

D2{=IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT(SUBSTITUTE(B$2&0," ",),SMALL(IF(ISERR(-MID(SUBSTITUTE(B$2&0," ",),ROW($1:$98),1))*ISNUMBER(-MID(SUBSTITUTE(B$2&0," ",),ROW($2:$99),1)),ROW($1:$98)),ROW(A1))),D1,REPT(" ",9)),9)),"")