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