remove cell contents if contains certain word in a specific column

Please use code tags with your code

This code looks for text in column B and can easily be changed to any column

Sub highlight()
Dim LR&, i&
With ActiveSheet

    LR = .Cells.Find("*", , , , xlByRows, xlPrevious).Row

    For i = 1 To LR
        If .Cells(i, "B") = "text" Then .Cells(i, "B") = ""
    Next
 End With
End Sub