Substring not found

  • Thread starter Thread starter Wayne Burrows
  • Start date Start date
W

Wayne Burrows

Hi

Is there a worksheet function that will return zero if a substring is not
found?

similar to
=Find("Text","Something Else") but returns zero.

TIA

Wayne
 
Hi Wayne

One way:

=IF(ISERROR(FIND("Text","Something Else")),0,FIND("Text","Something Else"))

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 
Back
Top