Try something like

If InStr(Cells(X, "H").Text, "RG") 0 Then
Cells(X, "G").Value = "TRC"
End If

Steve

"richzip" wrote in message
...
I apologize if this is here twice--I don't see the post I thought went
through earlier today. Anyway ..

I have the following code:

If .Cells(X, "H") = "RG" Then
.Cells(X, "G").Value = "TRC"
End If

Can I modify this with a "wildcard" character? In other words, if RG is
found anywhere (RG123, RG456, 123RG, etc) within cell H, I want TRC to be
placed into column G

Thanks!