公式
=IFERROR(MID(SUBSTITUTE($A2,F$1&":","@"),SEARCH("@",IF(ISNUMBER(SEARCH(F$1,$A2)),SUBSTITUTE($A2,F$1&":","@"),""))+1,SEARCH(";",SUBSTITUTE($A2,F$1&":","@"),SEARCH("@",IF(ISNUMBER(SEARCH(F$1,$A2)),SUBSTITUTE($A2,F$1&":","@"),""))+1)-(SEARCH("@",SUBSTITUTE($A2,F$1&":","@"))+1)),"")
具体操作如下:
如果帮到您记得点赞或关注哦。