I have a text string that I want to search to find a particular sub-string
and I am using the SEARCH function. If the result fails to find it, the
result is the #VALUE!. Is there a way to display a zero (0) instead - I would
like to manipulate the result.
Thanks.
--
David