HTML translation file - extract the text between tags

Hello everyone,

I am in front af an issue I am sure you guys can help me with.

I have a file with a bunch of HTML code on which I need to translate the text between the HTML tags.

Instead of doing it manually on Notepad++, I would like to create an excel file in which the content to be translated will appear on a separate cell (it will allow some automation and a faster process).

My original cell is as per below :

Please Login or Register  to view this content.

I would like it to look like this :

Please Login or Register  to view this content.

each cell being the part of the code to be modifiable.

Please find attached an example file of what i would like to implement :
- tab1 = base data
- tab2 = outcome expected

Thanks a lot for your great help

For the data uploaded.

Please Login or Register  to view this content.

thank you so much for your help jindon