Find specific word in sentence

[nigelk]

I'm trying to see if a sentence contains a specific word (for example, "ball" ) using the following formula:

=IF(ISNUMBER(SEARCH("ball",A1)),"Yes","No")

where A1 contains the text to be searched.

However, it makes no distinction between the words "ball" and "balloon" , and I get a positive result for both words.

Can anyone help?

Thanks,Nigel.

 

[VBA Geek]

have u tried

=IF(ISNUMBER(SEARCH(" ball "," "&G7&" ")),"YES","NO")

 

[Blade Hunter]

have u tried

=IF(ISNUMBER(SEARCH(" ball "," "&G7&" ")),"YES","NO")

Nice way to catch if it is first or last word too

 

[nigelk]

Works a treat, and a very speedy response.

Thanks,Nigel