Hi,
Use a web query with full HTML Formatting.



DATA Import External query

or try my WebTableImport utility at
http://www.geocities.com/excelmarksway

- Mark


"Davud Levitt" wrote:

Hi All,

If I copy a html table from a website such as
http://screen.yahoo.com/b?mc=/100000...ocks&vw=1&b=21
and then past the contents into Excel using the Paste Special HTML pasting
command the last column in my spreadsheet no longer contains the hyperlinks
that were contained within the copied website. I should note that I do not
have this problem when pasting the same website content into Microsoft Word.
Does anyone know this is happening in Excel and is there an easy work around
for this problem.

Thanks,

David Levitt