Excel Search function

D

dm2504

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.
 
T

Tom Ogilvy

For clarity
to show a zero it would be modified to

=IF(ISERR(SEARCH("ccc",G8)),0,SEARCH("ccc",G8))
 
Top