刪前面關鍵字 (14936)

C2=SUBSTITUTE(B2,LOOKUP(1,0/(FIND(F$2:F$8,"@"&B2)>1),F$2:F$8),)

I2{=SUBSTITUTE(B2,INDEX(H:H,RIGHT(MAX(IF(IFERROR(FIND(H$2:H$9,"@"&B2),99)=2,LEN(H$2:H$9)/1%+ROW($2:$9))),2))&"",)