An IF statements that operates if a cell CONTAINS a word...
Posted by Chris Rock on October 24, 2001 1:53 PM
Is it possible to write an IF statement that looks at a string of text, and will perform an action if the string CONTAINS a certain word?
For example. IF this statement in cell A1 contains the word "dog", write "dog". Otherwise, write nothing.
"I went to the pet store and I bought some dog food."
I can't put =IF(A1=dog,"dog","") because A1 doesn't EQUAL "dog", it CONTAINS "dog".
Or is there a better way to do this?