Excel Search function

[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.
--
David

[Don Guillett]

use isserr
=IF(ISERR(SEARCH("ccc",G8)),"",SEARCH("ccc",G8))
--
Don Guillett
SalesAid Software
[email protected]
"dm2504" <[email protected]> wrote in message
news:[email protected]...
>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

[Tom Ogilvy]

For clarity
to show a zero it would be modified to

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


--
Regards,
Tom Ogilvy



"Don Guillett" <[email protected]> wrote in message
news:[email protected]...
> use isserr
> =IF(ISERR(SEARCH("ccc",G8)),"",SEARCH("ccc",G8))
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "dm2504" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>