Search text inside a string

Hi all
is there any easy way to implement this :

IF (target_string contains searched_string) then say ("ok")
ELSE say ("not ok")

in a cell ?
I though it was a very easy thing,
so I was coding :
IF (FIND("this text","text"),"fine","not good")

but then I realize that FIND returns #VALUE if it doesn't find the searched_string, an I don't know how to manage it

IF (FIND("this txt","text"),"fine","not good") ==> #VALUE!

thanks in advance
*pimar

Hi,

If you are looking for a function to find word in word ...

Please Login or Register  to view this content.

In your VBE, you also need to tick off Tools Referrences
Microsoft VBScript Regular Expressions 1.0

HTH
Carim