Hyperlinks

Question

I have an excel sheet with websites and hyperlinks. I want to only show the text to display name with the hyperlink attached and only click that to open the URL. I know I can change the text to display name on each one individually, but this is time consuming. Is there a script that will attach the URL in the text to display name all at once? Currently I have Column A with the name and Column B with the URL but I want to eliminate Column B.

Answer 1

Thank you Charmaine for sharing this solution with the Community; it will be helpful to others who have similar inquiry.

Warm regards

Answer 2

I figured it out. Was quite simple. No VBA or script needed. I clicked Formula in menu, added my parameters and dragged the result down to display hyperlink with only website name, not full url.

Answer 3

how about build html then save as xlsx?

html as below

<a href=website>name</a>

Answer 4

Hi,

We understand it was a poor experience and sorry you were impacted. We hope you can stick with it and continue to troubleshoot the issue with us. As the same issue may have different root cause.

kindly use the steps in the link below:

https://www.ablebits.com/office-addins-blog/excel-hyperlink-function/

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

If you require any further assistance please don’t hesitate getting in contact. Best regards Ayo