Hello:

How to make this formula based on "contains" rather than "equals"? My
attempts are not working:

With Range("[range]")
.FormulaR1C1 = "=(OR(RC[-1]={""Text1"",""Text2"", ""Text3"})"
End With

I have a string and I need to know which "contain" either of the three
texts. I've played around with mid and instr with no success.

Thanks, Germain