Search function in sequence with characters

I have a problem with an Excel file, the formula I use

Code:

---

=IF(ISERROR(SEARCH(BN$3;$B$4));"";1)

---

In the box BN3 is entered, for example, Datastage. But if the word Datastage is written on one line but the form following:

Quote:

---

xxx/datastage/yy/zz,

---

Excel will not pull me information.

My hope is to raise the keyword content in cell BN3 but even if this keyword is a character sequence.

Code:

---

=IF(LEN (A1)=LEN(SUBSTITUTE(A1;A2;""));"";1)

---

the principle is that the function substitute () replaces a string with another and does nothing if the string is not present. If asked to replace the empty string "", length is unchanged if that is not present and it will decrease this.

Try this:

Code:

---

  IF (ISERROR (SEARCH ("*" &BN$ 3 & "*" ;$B$ 4)) ; "" ; 1)

---

I think the problem is that Excel automatically interleaves depending on whether the text position where it is copied to another file. You can change the options in excel on the subject but it will reverse the problem and the desired words would not be found:
Tools/Options/Spelling and AutoCorrect lists replace, delete.