如何提取指定信息

张广玉

=TEXTJOIN("、",1,IF(ISNUMBER(FIND($F$2:$F$7,B2)),$F$2:$F$7,""))
三键结束，下拉

石敬晨

=TEXTJOIN("、",1,IFERROR(MID(B2,FIND($F$2:$F$7,B2),2),""))

活成一个梗

=TEXTJOIN("、",1,IF(COUNTIF(B2,"*"&F$2:F$7&"*"),F$2:F$7,""))

时间的谎言丶

卢聪

=TEXTJOIN("、",1,IFERROR(IF(SEARCH($F$2:$F$7,B2),$F$2:$F$7,),""))

误解依旧答案永恒

(2007版) E2右拉 下拉{=IFERROR(IF($A$1=A$1,"","、")&INDEX($C:$C,SMALL(IF(ISNUMBER(FIND("、"&$C$2:$C$12&"、","、"&$B2&"、")),ROW($2:$12)),COLUMN(A1)))&F2,"")

禹轩

=TEXTJOIN("、",1,IF(SUBSTITUTE(B2,F$2:F7,)<>B2,F$2:F7,""))

花悟泪

=TEXTJOIN("、",1,IF(ISNUMBER(FIND(TRIM(MID(SUBSTITUTE(B2,"、",REPT(" ",99)),1+99*(COLUMN($A:$Z)-1),99)),$F$2:$F$7)),TRIM(MID(SUBSTITUTE(B2,"、",REPT(" ",99)),1+99*(COLUMN($A:$Z)-1),99)),""))

三键下拉