I have series of links in excel sheet that links to company's intranet page
which is in html format. I have to copy certain text contents from it and
paste it in particular cell in excel.

Regards,
Joseph