EXCEL如何比對儲存格中之部份字串? - Yahoo!奇摩知識+

B1=IF(OR(ISNUMBER(FIND({"yahoo","雅虎","資料來源","版權所有","第一頁","第二 頁","第三頁"},"*"&A1&"*")))+COUNT(A1),1,"").

tw.knowledge.yahoo.com