• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search any particular word

Hi,

I am trying to search for any particular word within a statement.

For e.g. if a statement contains the word "Land", it should return "False", but it should not return False, if any word contains "Land", for e.g. "Portland". In other words, it should search for the standalone word only.
 

Attachments

  • Search Formula.xlsx
    8.8 KB · Views: 8
I don't understand as to why 4th case shall return false. Otherwise you could use below formula:

=ISNUMBER(SEARCH(" land "," "&D4&" ",1))
 
Back
Top