Delete specific text in spreadsheet

S

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
 
G

Gary''s Student

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

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
 
Top