Substring not found

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
 
L

Leo Heuser

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.
 

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
search text for substring and change text colour of substring 5
How do I handle error conditions with the FIND command? 6
Text string searches 3
Word macro that can call cells out of Excel for a find and replace 0
Count occurrences of a substring in an array 4
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Multiple arguments 3

Top