Make worksheet function SEARCH return zero, not an error, when te.

W

WDAGrant

There is no INSTR equivalent in Excel worksheet functions.
SEARCH and FIND return errors when the search text is not found.
You can get round this with ISERROR but this seems clumsy
 
F

Frank Kabel

Hi
no chance without using ISERROR or as alternative ISNUMBER. e.g.
=IF(ISNUMBER(FIND(...)),result,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help finding a substring in a array of strings. 1
FIND function does not return ZERO when text is not found 5
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
How do I set focus (and select text) on a text box on a modeless userform? 0
FUNCTION THAT SEARCHES DATA AND RETURNS INFO ON A DIFFERENT WORKSH 2
Trapping errors in a VLOOKUP function 1
return proper match from three columns 2
Unexplained failure of wdFindStop at end of search 0

Top