Can I remove the "Text to Display" from multiple cells with hyperlinks and just leave the URLs?

[douglerner]

I created a spreadsheet by copying a table on a web page and pasting it into Excel. This is on my Mac.

One column are hyperlinks. Each hyperlink has a Text to Display that says "View the Recording". If I hover over the links I see the URLs to each recording. I can also see the URLs if I control-click on one URL and remove the Text to Display.

But I have hundreds of these rows. Is there a way of selecting them all and doing something to just leave the visible URLs in each row? Or grab all the URLs and paste them into another column? Basically is there any way of showing just the URLs without editing each one manually

I'm trying to provide the list of URLs to somebody. I don't need them to be hyperlinked. 

Thanks,

doug

[#2]

@douglerner You can do this with a macro - e.g. see this page.