[SOLVED] Searching A Cell for multiple text strings (a whole list) with one formula?

Hi
Try this code VBA in a Module

Function Subst_every(a As String, b As Range) As String
    Dim i As Integer, s As String
    s = a
    For i = 1 To b.Rows.Count
        s = Trim(Application.WorksheetFunction.Substitute(s, b(i), ""))
    Next i
    Subst_every = s
End Function

Use this formula in the gray area
=SUBST_EVERY(A2,$B$2:$B$55)
and copy down

$B$2:$B$55 is your "Table for Branded Terms"

See if this help