converting rtf tables spanning several pages to excel

[Elsu]

Hello Everyone,
I am new to this forum and I'm trying to be more literate with Excel. I hope someone can help me with this question.

I have several data tables that are in rtf and several of those tables span more than one pages. As a result the table title rows and footnotes are repeated in each page. Eventually, my goal is to use these rtf tables in a report I am writing.

I can copy paste single page rtf tables into my report without an issue, but the tables that span several pages is tedious work; I have to merge the tables and remove the repeating headers and footnotes (keeping only the header at the top and footnote at the bottom).

I thought maybe I can write a macro in excel whereby I can call in the rtf table and it automatically can be cleaned up. I can therefore just copy this cleaned table from excel into my document. Before I waste my time, does this seem like a logical plan? Does anyone else know how to do this better?

Thank you!
Elsu

[AliGW]

Welcome to the forum.

Please attach a sample .rtf file here with a table spanning two pages. It mught be possible with PowerQuery, but will need testing.

If you are unable to attach the file as is, change its suffix to .zip before uploading.

Instructions on how to upload in the yellow banner at the top of the page.