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"....
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 RunSub
And you've saved so much time!
Good luck,
Joan