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,"")
 
Top