Forum Discussion
Can I remove the "Text to Display" from multiple cells with hyperlinks and just leave the URLs?
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 Replies
douglerner I had a similar problem and found this code from Ablebits: https://www.ablebits.com/office-addins-blog/hyperlink-excel-create-edit-remove/ . Go to Section: Extract multiple URLs by using VBA
If you don't know how to use VBA, I found this link helpful: https://blog.enterprisedna.co/how-to-view-vba-code-in-excel/
Some items are of course extra information, so the steps I used from this article are:
Accessing the VBA Environment - 1. Enabling Developer Tab
Then on the Developer tab button > click "Visual Basic" > double click on the sheet I have the links > paste the VBA code in the Code Window > Press RunSubAnd you've saved so much time!
Good luck,
Joan
douglerner You can do this with a macro - e.g. see this page.
