拆 後括弧刪除數據 (12719)

(先)C2=SUBSTITUTE(RIGHT(SUBSTITUTE(A2,"(",REPT(")",9)),9),")",)

B2=LEFT(A2,FIND("("&C2,A2)-1)

一公式 B2:C4=TRIM(MID(SUBSTITUTE(LEFT($A2,LEN($A2)-1),"(",REPT(" ",9),LEN($A2)-LEN(SUBSTITUTE($A2,"(",))),COLUMN(A1)*9-8,9))

一公式 B2右拉後 才正確=IF(B$1=$C$1,SUBSTITUTE(RIGHT(SUBSTITUTE($A2,"(",REPT(")",9)),9),")",),SUBSTITUTE(A2,"("&C2&")",))