Excel 怎么判断一句话中包含某个字答:假设在检查A1单元格中是否包含有关键字“张”字,则可以在B1单元格写入公式:公式一=IF(ISNUMBER(FIND("张",A1)),"有","")公式二=IF(ISERROR(FIND("张",A1)),"","有")公式三=IF(COUNT(FIND("张",A1)),"有","")公式四=IF(COUNTIF(A1,"*张*"),"有","")...
请教,如何判断excel某个单元格内是否含有某个字符?答:假设是判断excelA1单元格内是否含有"#"号字符,则\x0d\x0a另一单元格写入公式\x0d\x0a=IF(COUNT(FIND("#",A1)),"包含","不包含")\x0d\x0a或\x0d\x0a=IF(COUNTIF(A1,"*#*"),"包含","不包含")\x0d\x0a再或\x0d\x0a=IF(ISERROR(FIND("#",A1)),"不包含","包含"...