Suppose I have a hyperlink in cell A1: =hyperlink("stackexchange.com", "Stack Exchange") Elsewhere in the sheet, I'd like to have formulas that get the link text and URL from A1, separately. I found a way to get just the link text: =""&A1 (concatenation with empty string). This returns "Stack Exchange", unlinked. How to get the URL (stackexchange.com)?
![Extract the link text and URL from a hyperlinked cell](https://cdn-ak-scissors.b.st-hatena.com/image/square/975b85f2047bea7c51143988f1af195fd2c0c70a/height=288;version=1;width=512/https%3A%2F%2Fcdn.sstatic.net%2FSites%2Fwebapps%2FImg%2Fapple-touch-icon%402.png%3Fv%3Df700edad5c7b)