Text extraction from News Articles Into Excel

Hello,
I am running into the following challenge, and would really appreciate some serious help with a VBA code/process.
I have been tasked to extract full text from hundreds of URLs and put them in unique cells. The only way I see will be using a VBA code.
Here is an example of what I have been trying to do using this URL,

HTML Code: 

I extracted the full text using boilerpipe, which is found here:

HTML Code: 

I then recorded the following micro using the web import wizard in excel:

Please Login or Register  to view this content.

This imports the text into multiple cells in the the same column. But to automate the import process for a large number of URLs and to make things visually appealing, I need to have the entire full text imported in a single cell.

Any help/suggestion will be appreciated.

Thanks!

Hi JasperD,
Thanks for the code. It worked nicely. Is there a way though that I could extract text without using boilerpipe...just wondering.

Hey, JasperD I am problem extracting from URLs gotten from google alert. Maybe you could help...here is the new thread I started

HTML Code: