Delete specific text in spreadsheet
 

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

Delete specific text in spreadsheet
 

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

Delete specific text in spreadsheet
 

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