I have a text report I import into excel that has headers and blank rows between the headers.

I need some code to delete rows that begin with specific words, such as "subscriber", or "Payment type", and also deletes any blank rows.

Thanks