Finding a few words in a particular String.

[Jackcell]

Hi all,

I would need to find multiple words inside a String. An example of the String: "I need to buy apple, pear, orange and other fruits"

I need to the expression to find apple, pear and orange inside the string. Is it possible to find all at once or do I have to find a word by a word.

Cheers,
Jack

 

[István Hirsch]

Try this:

=IF(COUNTIF(A2,"*apple*")*COUNTIF(A2,"*pear*")*COUNTIF(A2,"*orange*"),"found","not found")

 

[Jackcell]

The string is in a variable and not a cell. I would assume COUNTIF only works for excel cell

 

[Fluff]

If you simply want to check if all words occur in the string, try

Sub chk()

   Dim s As String
   
   s = "I need to buy apple, pear, orange and other fruits"
   If InStr(s, "apple") * InStr(s, "pear") * InStr(s, "orange") Then
      MsgBox "found"
   Else
      MsgBox "Not found"
   End If

End Sub