If you are referring to my code

Sub replace()
With Range("B1", Cells(Rows.Count, 2).End(xlUp))
    .replace "*text*", Empty
End With
End Sub