Wildcard operators to use with LIKE

[LuisE]

I’m using LIKE to determine if a cell contains certain text, but I don’t know
how to use the wildcard characters or how to structure a pattern to make the
search effective.
I want to find any cell with the text “traf10†in it not necessarily being
that string the only content of the cell.

If Cell2Srch.Value Like "traf10" And Not Cell2Srch.Value Like "traf106" Then
Cells(Cell2Srch.Row, 1).Value = "Yes"
End If

Thanks in advance

 

[Mike H]

Hi,

Try this alternative to like

If InStr(cell2srch, "traf10") And Not InStr(cell2srch, "traf106") Then
Cells(cell2srch.Row, 1).Value = "Yes"

Mike

 

[TomPl]

I think the wild cards would make it look like this:

If Cell2Srch.Value Like "*traf10*" And Not Cell2Srch.Value Like "*traf106*"
Then
Cells(Cell2Srch.Row, 1).Value = "Yes"
End If

Tom

 

[Rick Rothstein]

This should do the same thing PROVIDED there is always at least one
character following the 'traf10' characters...

If Cell2Srch.Value Like "*traf10[!6]*" Then

 

[Rick Rothstein]

I guess this version will work properly even if there is no character
following the 'traf10' characters...

If Cell2Srch.Value & " " Like "*traf10[!6]*" Then

--
Rick (MVP - Excel)

This should do the same thing PROVIDED there is always at least one
character following the 'traf10' characters...

If Cell2Srch.Value Like "*traf10[!6]*" Then

--
Rick (MVP - Excel)

I think the wild cards would make it look like this:

If Cell2Srch.Value Like "*traf10*" And Not Cell2Srch.Value Like
"*traf106*"
Then
Cells(Cell2Srch.Row, 1).Value = "Yes"
End If

Tom