If cell contains ...

[irisqueiroz]

Please,


I'd like to write a If statement like this:


If cell contains the text "abc" then do that ...


But the cell value can be "abc def", "abcdef" etc. The important it to have the word "abc".


Thanks

 

[Trader273]

See if this helps:

https://www.dropbox.com/s/akot2uhrthbpw4z/Find%20abc.xlsx

 

[Luke M]

=IF(ISNUMBER(SEARCH("abc",A2)),"Do this","DON'T DO IT!")