Hyperlink Copy
 

If I save a HTML page to an Excel file, it keeps the hyperlinks that
were in the htm page.

If I copy a range, that contains hyperlinks, from the Excel file to
another spreadsheet, the hyperlink changes and only shows a portin of
the link, not the whole link address which is an html page.

Any suggestions?