拆分 數字與前面非數字 為一筆 (14937)

D2:G5{=IFERROR(TRIM(RIGHT(SUBSTITUTE(LEFT($B2,SMALL(IF(ISNUMBER(-MID($B2,ROW($1:$49),1))*ISERR(-MID($B2,ROW($2:$50),1)),ROW($1:$49)),COLUMN(A1))),C2,REPT(" ",99)),99)),"")