View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Convert Hyperlinks
 
Posts: n/a
Default 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.