5 Replies Latest reply on Dec 28, 2016 2:25 PM by Sagar Sanjay Joshi

    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