Extract data after specific text from webpage

Hi,

I was wondering if there was a way to extract a specific line of text from a webpage and return it to a cell.
I currently have a working formula to extract all of the text from the page, but i could do with it only pasting the line "Unit per box:" and the number following that.

The VBA im using is:

Please Login or Register  to view this content.

This searches the website with the gap in the url being filled with the data in A1 and then pastes all of the text from that page.

At the moment, ive just put a formula in C1 that looks at all the text pasted and returns the correct info after the ":" symbol:
=RIGHT($A$275,LEN($A$275)-FIND(": ",$A$275)) ), but below that is ALL of the text from the page.

Originally Posted by Arkadi

marcosis,

You say it won't let you write the url... you mean the site won't accept it? if so could you provide it like this? www dot google dot com

Hey Arkadi!

Www dot arqadia dot Co dot uk

If you select any moulding or frame on that website you'll see a unit or box. That's what I need.

Cheers