Please take a look at the attached workbook and let me know how to modify the macro below so that it returns only the full string when its presence is detected in a table that includes partial strings as well.
In fact if there is a simpler way to zero in on any combo of 2 or more contiguous letters drawn from a set string (in this case "ABCDEFGHJKL") without the need for the table in the first place, please let me know that as well.
Dim cel As Range, x As Long, y As Long, z As String
x = [MyCell].Row
y = 50
For Each cel In [Table1]
If Len(cel) > 2 Then
If InStr([MyCell], cel) > 0 Then
Cells(x, y).End(xlToLeft).Offset(0, 1) = cel