SEARCH function, help needed!

Hello,

I am trying to use the SEARCH function for string searching. I know that the search function will return a value if it finds the matching string, however if it does not find the matching string, it returns:

#VALUE

Can that be changed to 0, or something else I can work with?

For example, if I have in Cell A1: Hello World
And in Cell A2 I have the formula: Search("hello",A1,1)
The search function will return the value "1" (the first instance it comes across "hello" in cell a1).

However, if I put in cell a2: Search("bye",a1,1)
The function will return #VALUE - and I can't work with that! It would be great if it returned "0" - indicating it didnt' find it.

Any ideas?? Maybe I'm using the wrong function ?? Thanks!!

Ali

that's perfect! thanks!!