Hyperlinks Text

Occasional Visitor


Dear Excel Community,


I hope you are are safe and doing well in these challenging times. I need help on below.


I copied data from a webpage and pasted as "Keep Source Formatting" in an excel. Few cells have Hyperlinks to another webpage but I am unable to see the Hyperlink text. I only see the Name of the Hyperlinks.


If I click on the cell, hyperlink is opening in the browser but I want to copy text address of the hyperlink. I can see the hyperlink text when I hover the cursor on the cell.


Any help is appreciated!

0 Replies