括號數字後面字符 提出 (11204)

B3:F3=MID(MID($A3,FIND(B2,$A3)+LEN(B2),99),1,FIND("(",MID($A3,FIND(B2,$A3)+LEN(B2),99)&"(")-1)

另解=MID(TRIM(MID(SUBSTITUTE($A3,B2,REPT(" ",99)),99,99)),1,FIND("(",TRIM(MID(SUBSTITUTE($A3&"(",B2,REPT(" ",99)),99,99)))-1)