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