取括弧內數字 (12359)

 B2=-LOOKUP(9,-MID(A2,FIND("(",A2)+1,ROW($1:$9)))

括弧內可數字與字符 長度不限 9字元=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"(",")"),")",REPT(" ",99)),99,99))