Can Excel 97 paste only URLs?

I'm just meeting Excel 97 for the first time and discovered I can copy and paste a web pages table into a spreadsheet. Unfortunately, URLs in the table are not visible on the pasted spreadsheet. I'd like the cells to not display the "Friendly name",as this causes the user to depend on the spreadsheet to remember the URL, and thus they won't know where to get the information later.