拆單元格數字與文字 (11898)

A6{=MID(A$3,SMALL(IF(ISNUMBER(-MID(A$3,ROW($1:$99),1))*ISERR(-MID("A"&A$3,ROW($1:$99),1)),ROW($1:$99),99),ROW(A1)),3)

B6{=IF(A6="","",MID(A$3,FIND(A6,A$3)+3,MATCH(1=1,ISNUMBER(-MID(A$3&9,FIND(A6,A$3)+ROW($1:$9)+2,1)),)-1))