Convert Hyperlink to cell value automatically
 

I have a spreadsheet that lists company names with an attached hyperlink to
their website. I need to import the data from excel and would lke to import
the web address. Can I convert the name to the web address or create it as
an additional column for each of the rows. I do not wish to copy each
hyperlink manually.