Hyperlinks Text

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!