Hyperlink in display name

Question

UPDATED:
I used FORMULAS, selected INSERT FUNCTION, and chose HYPERLINK. Entered the formula parameters and dragged the result down and now all the names are the hyperlink! I forgot how I was able delete the original columns, but these can also be hidden instead of deleting them. I do remember a screen at some point with an option the select Text or Unicode Text but I'm unable to replicate that action. Another option is to copy the formulated column to Word, select copy, open the Excel sheet, go to the column and first cell you want the data in, select paste options, choose keep source formatting. Delete the columns with the data used to create the formula! All is well!

On excel sheet:
I have a website name on column A
I have the URL on Column B
I only want to click column A with hyperlink attached to website name.
I know I can open each URL individually and specify the text to display for each URL but this is time consuming.
Is there a script to add the URL in Column B to the text to display in Column A?




Example:
COLUMN A COLUMN B
NAME WEBSITE
Google https://google.com
Microsoft https://microsoft.com
Amazon https://amazon.com

Answer 1

Hi @CharmaineKavanagh

You will need to enable VBA (Developer Tab) to use the following script:

Private Sub hyper()  
  
ActiveCell.Hyperlinks.Add Anchor:=Sheets("sub").Range("A1"), Address:="https://www.educba.com/", SubAddress:="", ScreenTip:="it is a Hyperlink", TextToDisplay:="Excel Training"  
  
End Sub  

Cited from https://www.educba.com/vba-hyperlink/ (you can see the follow example in this link). You will just need to create a loop that looks through each row and use B# as the link for A#.

-------------------------------------

If this is helpful please accept answer.

----------------------------------------

If this is helpful please accept answer.

Answer 2

Figured it out. I used FORMULAS and chose HYPERLINK. Created the formula and dragged the cell down and now all the names are the hyperlink!