Deleting page breaks from text file imported into excel?

[Haihud]

Hi
I am trying automate deleting the headers and footers from .txt file that I import into excel.
Note the .txt file extends to more than 100 pages.

Thank you in advance.

 

[rlv01]

Three potential ways:
1. Power Query. I understand that Power Query is capable of doing this, so you might consider posting a question in that forum.
2. Open the text file with Excel, headers and footers included, and then use a VBA macro (that you write) to remove the headers, footers and page breaks.
3. Write a VBA macro to directly open the text file, and read it line-by-line, and transfer only the data that you want into a blank worksheet.