Excel VBA INSTR Function
Using this simple VBA code we cab find any string available in a sentence.
Sub Findstr()
sheets("Master").Range("B2:B100").ClearContents
For i = 2 To sheets("Master").Range("A" & Rows.Count).End(xlUp).Row
If InStr(1, sheets("Master").Range("A" & i), sheets("Master").Range("F1").Value) 'Use greater than symbol' 0 Then
sheets("Master").Range("B" & i).Value = "Yes"
End If
Next
End Sub
