Sub Macro1()
Cells.Replace What:="REASON CODES", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
You may also use Macro Recorder to record a macro with your search parameters.