I've got a hyperlink that I've copied from a website and put into a Google Sheet.
If you hover over the hyperlink it shows you it is an active link and you can click it.
But if you view the formula in the cell you can't see the
=hyperlink() function being used. See screenshot below.
I want to be able to generate a list of raw URLs from these hyperlinks, is there anyway I can do that in Google Sheets ? (FYI I've also tested in Excel which has the same issue of not using the
I've made a test version of the sheet here in case someone wants to try.