如何提取指定信息

胡瑞飞

=TEXTJOIN("、",1,IF(1-ISERR(FIND(F$2:F$7,B2)),F$2:F$7,""))
三键盘公式

火乐

=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)),""))

三键下拉

神奇的木头

=TEXTJOIN("、",1,IF(1-ISERR(FIND(F$2:F$7,B2)),F$2:F$7,""))
三键盘公式