用Excel函數搜尋字串- Yahoo!奇摩知識+

只針對"睡覺"這兩個字的話. B1請輸入以下公式. =IF(ISERROR(FIND("睡覺",A1))," Error","睡覺"). 或. =IF(LEN(SUBSTITUTE(A1,"睡覺",""))=LEN(A1),"Error" ...

tw.knowledge.yahoo.com