第一與最後數字 一公式提取 (14917)

B2:C8{=INDEX(RIGHT(SMALL(IFERROR(MID(SUBSTITUTE($A2,"："," "),SMALL(IF(ISERR(-MID("A"&$A2,ROW($1:$28),1))*ISNUMBER(-MID($A2,ROW($1:$28),1)),ROW($1:$28)),COUNT(0/(ISERR(-MID("A"&$A2,ROW($1:$28),1))*ISNUMBER(-MID($A2,ROW($1:$28),1))))^{0;1}),COLUMN(A:I))*1,)+{1;2}*10^9,{1,2}*9),9),COLUMN(A1))*1