Break Link fail in "Data" - "Edit Links"

check "Fomulars" - "Name Managers" to remove the names linked to the external file.

EXCEL判断字符串中是否包含某个特定子串的公式总结

例： A列 中输入字符串： "提前祝大家元旦快乐！", B列中输入公式判断是否包含子串 "大家", 包含返回"大家快乐!", 不包含返回"各位快乐!".

1. COUNTIF

=IF(COUNTIF(A1,"大家"),"大家快乐!", "各位快乐!")

2. LEN与SUBSTITUTE组合

=IF(LEN(A2)-LEN(SUBSTITUTE(A2,"大家","")),"大家快乐!", "各位快乐!")

3. FIND与LEN组合

=IF(FIND("大家",A3&"大家")<=LEN(A3),"大家快乐!", "各位快乐!")

4. ISNUMBER与FIND组合

=IF(ISNUMBER(FIND("大家",A4)),"大家快乐!", "各位快乐!")