拆括號內二數字 (10890)

E1:F8=TRIM(MID(SUBSTITUTE(MID($B1,2,LEN($B1)-2),",",REPT(" ",99)),COLUMN(A1)*99-98,99))

區域數組 H1:I8{=TEXT({1,-1},SUBSTITUTE(MID($B1,2,LEN($B1)-2),",",";"))

另解{=INDEX(TEXT({1,-1},SUBSTITUTE(MID($B1,2,LEN($B1)-2),",",";")),COLUMN(A1))