6 Replies Latest reply on Jul 12, 2018 3:35 PM by Stephen Hicks

    ISNUMBER

    Barb Reiser

      Can someone help me with finding out how to edit this formula to search for an exact match. I only want it to find the word ant. Right now it pulls words like want, wanted, and chalant.

       

      =IF(ISNUMBER(SEARCH("*ant*",K5)),"ant","")

       

      Thank you,

      Barb