你即將離開本站

並前往https://stackoverflow.com/questions/14803944/excel-searching-for-multiple-terms-in-a-cell

Excel: Searching for multiple terms in a cell - Stack Overflow

Another way =IF(SUMPRODUCT(--(NOT(ISERR(SEARCH({"Gingrich","Obama","Romney"},C1)))))>0,"1",""). Also, if you keep a list of values in, ...

確定！ 回上一頁

查詢 「Excel SEARCH」的人也找了：

  1. excel尋找文字公式
    2.
  2. Excel FIND
    3.
  3. excel尋找字串
    4.
  4. excel find從右邊
    5.
  5. excel find找不到
    6.
  6. excel find多個
    7.
  7. excel find多個儲存格
    8.
  8. excel搜尋字串回傳位置
    9.