刪除括弧內人名 (9569)

C2=IFERROR(SUBSTITUTE(A2,"（"&LOOKUP(1,0/(FIND(F$2:F$9,"@"&A2)>1),F$2:F$9)&"）",),A2)

姓名不在末端 有誤=IFERROR(LEFT(A2,-LOOKUP(,-FIND("（"&F$2:F$9&"）",A2))-1),A2)