Removing every instance of a text value I dont want

Hi,

I have a report ive been working that's usually takes in about 400 entries in 7 different columns that are generated by an external system. When this system exports everything into an excel file it includes the the headers on every sheet and sometimes multiple on the same sheet. This makes roughly 30 ish of the 400 entries just useless headers. I have been removing them manually with find and replace but really want to find a formula that removes them for me