请教，如何判断excel某个单元格内是否含有某个字符

假设是判断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,)),"不包含","包含")