Question

excel判定某个字符串里面是否含有某个字符串

如图，如果A列区域在D列里出现了，则在B列提示有，否则提示无，求教大神，记得给示范哦

Answer 1

假设某一特定字符是“φ”并在A1单元格(φ可改成想找的字符) B1=IF(ISNUMBER(FIND("φ",A1)),"有","无")

Answer 2

假设是判断excelA1单元格内是否含有"#"号字符,则
另一单元格写入公式
=IF(COUNT(FIND("#",A1)),"包含","不包含")
或
=IF(COUNTIF(A1,"*#*"),"包含","不包含")
再或
=IF(ISERROR(FIND("#",A1)),"不包含","包含")
=IF(ISNUMBER(FIND("#",A1)),"包含","不包含")
=IF(ISNA(MATCH("*#*",A1,)),"不包含","包含")
=IF(ISNA(VLOOKUP("*#*",A1,1,)),"不包含","包含")

追问

我提问的这个要怎么弄哦，能给个示范吗

Answer 3

C2单元格输入公式：
=IFERROR(LOOKUP(9^9,FIND($D$2:$D$3,A2),$D$2:$D$3),"无")
复制并下拉，即可

Answer 4

B2输入=IF(ISERROR(FIND(D2,A2)),"无","有")向下填充。