Excel - FIND - #VALUE! 1

[swtrader]

Am using =FIND(C1,B1,1) to find the beginning character count of a found string within another string.... i.e., B1 is "This is Item4 A"; C1 is "Item4" -- which returns 9. When I search a different string (that does not contain the term: "Item4" (such as "This is Item3"), the return is "#VALUE!".

I would like for the value to be set at 0 if the string was not found rather than returning #VALUE!. ??

Thank you.

swtrader

 

[AnotherHiggins]

For future reference, this isn't a VBA problem and should be posted in forum68.

[tab]=If(IsError(FIND(C1,B1,1)), 0, FIND(C1,B1,1))

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[swtrader]

Thanks.

Never as difficult as I make it.

Am writing VBA code and this is part of the "application". Aha, wasn't thinking about where this query should be. Rightfully noted.



swtrader
-- If you don't know where you're going, you'll always know when you're not there.

 

[AnotherHiggins]

No problem. Glad to help.


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.