software

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

use isserr
=IF(ISERR(SEARCH(quot;cccquot;,G8)),quot;quot;,SEARCH(quot;cccquot;,G8))
--
Don Guillett
SalesAid Software

quot;dm2504quot; gt; wrote in message
...
gt;I have a text string that I want to search to find a particular sub-string
gt; and I am using the SEARCH function. If the result fails to find it, the
gt; result is the #VALUE!. Is there a way to display a zero (0) instead - I
gt; would
gt; like to manipulate the result.
gt; Thanks.
gt; --
gt; David
For clarity
to show a zero it would be modified to

=IF(ISERR(SEARCH(quot;cccquot;,G8)),0,SEARCH(quot;cccquot;,G8))--
Regards,
Tom Ogilvy
quot;Don Guillettquot; gt; wrote in message
...
gt; use isserr
gt; =IF(ISERR(SEARCH(quot;cccquot;,G8)),quot;quot;,SEARCH(quot;cccquot;,G8))
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;dm2504quot; gt; wrote in message
gt; ...
gt; gt;I have a text string that I want to search to find a particular
sub-string
gt; gt; and I am using the SEARCH function. If the result fails to find it, the
gt; gt; result is the #VALUE!. Is there a way to display a zero (0) instead - I
gt; gt; would
gt; gt; like to manipulate the result.
gt; gt; Thanks.
gt; gt; --
gt; gt; David
gt;
gt;