Excel: Convert a Column with Hyperlinks to Just Display the Links
In Excel, I Have a Column of Links That Display Text Instead of the Actual Link. I Actually Need the Links, Is There a Way to Bulk Convert the Entire Column So...
In Excel, I have a column of links that display text instead of the actual link.
I actually need the links, is there a way to bulk convert the entire column so that the links are exposed? Otherwise I will have to click on each link, open it in a browser, and copy-and-paste the address...
Also, I'm in Excel 2008 for Mac so it looks like I can't do macros...
5 Answers
Short answer: you can't automate this without VBA.
Manual
This is on a Windows 7 computer; just replace the shortcuts with their corresponding Mac counterparts.
- Highlight a cell with a hyperlink.
- Press CTRL+K. This opens the hyperlink dialog box (see image below). Once it opens, you'll find that your cursor is already in the Address field.
- Press CTRL+A to highlight the entire URL.
- Press CTRL+C to copy it.
- Press ESC or Enter to close the Hyperlink dialog box.
- Paste the URL somewhere via CTRL + V.
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
