View embeddable link content in spreadsheet

[JohnP115]

Hello,

I'd like to add a live weather feed to display in my spreadsheet. I know how to add a hyperlink, but I want the content of the hyperlink to show not the hyperlink text itself. Is this possible?

Thank you!