Delete specific text in spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Sub Macro2()
Cells.Replace What:="Split Payment", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quick way for monthly linking of Excel sheets 0
VLookup multiple spreadsheets 2
Excel Typed text appears in wrong cell 0
comparing columns in two spreadsheets 1
Combining spreadsheets 4
Collate data from one spreadsheet into another spreadsheet 2
Function in Excel to count and list number of entries of text valuesin a row. 2
error with countif formula on when adding linked spreadsheets 0

Back
Top