例：A列中输入字符串："提前祝大家元旦快乐！",B列中输入公式判断是否包含子串"大家",包含返回"大家快乐!",不包含返回"各位快乐!". 1.COUNTIF =IF(COUNTIF(A1,"*大家*"),"大家快乐!","各位快乐!") 2.LEN与SUBSTITUTE组合 =IF(LEN(A2)-LEN(SUBSTITUTE(A2,"大家","")),"大家快乐!","各位快乐!")...