Delete specific text in spreadsheet

[SITCFanTN]

I'm thinking this is pretty easy to do, I'm new with VBA so would like your
help. I have a huge spreadsheet that I download each day and in this
spreadsheet is the phrase "Split Payment". I want to delele that text
anyplace it appears in the spreadsheet. How would I accomplish this? Thanks

[Gary''s Student]

Sub Macro2()
Cells.Replace What:="Split Payment", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

--
Gary's Student


"SITCFanTN" wrote:

> I'm thinking this is pretty easy to do, I'm new with VBA so would like your
> help. I have a huge spreadsheet that I download each day and in this
> spreadsheet is the phrase "Split Payment". I want to delele that text
> anyplace it appears in the spreadsheet. How would I accomplish this? Thanks

[Greg Wilson]

Further to Gary's post, you can use Excel's Find utility: Edit > Find
Use the Replace feature except leave the "Replace with" window blank.

Regards,
Greg

"SITCFanTN" wrote:

> I'm thinking this is pretty easy to do, I'm new with VBA so would like your
> help. I have a huge spreadsheet that I download each day and in this
> spreadsheet is the phrase "Split Payment". I want to delele that text
> anyplace it appears in the spreadsheet. How would I accomplish this? Thanks