提取并转置括号内数字 (10419)

D4:H4=-LOOKUP(9,-MID(T(OFFSET($C3,COLUMN(A1),)),LOOKUP(99,FIND({"(","{"},T(OFFSET($C3,COLUMN(A1),))))+1,ROW($1:$9)))

D5:H5=LEFT(T(OFFSET($C3,COLUMN(A1),)),LOOKUP(99,FIND({"(","{"},T(OFFSET($C3,COLUMN(A1),))))-1)

D6:H6=MID(T(OFFSET($C3,COLUMN(A1),)),LOOKUP(99,FIND({")","}"},T(OFFSET($C3,COLUMN(A1),))))+1,9)