Hi Yudlugar,

I believe there was a macro enabled button on the sheet, So basically I had to copy the links from the Excel sheet and paste it on this Excel on specific column and then extract the description using the button, its been quite a while I used, there are thousands of these links for which I need to extract the description. Am just stuck. Please help