张广玉 发表于 2021-12-30 22:09:48

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

石敬晨 发表于 2022-1-11 04:58:12

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

活成一个梗 发表于 2022-1-17 20:13:08

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

时间的谎言丶 发表于 2022-1-22 02:21:08

卢聪 发表于 2022-1-24 13:26:29

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

误解依旧答案永恒 发表于 2022-1-26 11:39:42

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

禹轩 发表于 2022-1-29 11:00:36

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

花悟泪 发表于 2022-1-31 23:29:02

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

三键下拉
页: 1 2 [3]
查看完整版本: 如何提取指定信息