After using importRange to get Hyperlinked cells, how do you get the value of the URL? <p>I was trying to help someone solve a problem the other day and I came across an interesting issue I couldn't solve.</p> <p>Imagine two sheets. One containing HYPERLINKS created by HYPERLINK function in Google Sheets, such as this sheet. <a href="https://docs.google.com/spreadsheets/d/1hVr-PnmpAj7VaT6xTfwhMAS2zi-JzruDZcjvHzQIpyk/edit?usp=sharing" rel="nofollow">Source Sheet</a></p> <p>Then you have another sheet that uses importRange to import these URL's, like this sheet. <a href="https://docs.google.com/spreadsheets/d/1r5Zt-7ByW8A17kKPdcIBs_gzH8RuM4n3Q5aW6mHxyKM/edit?usp=sharing" rel="nofollow">import Sheet</a></p> <p>The URLs import correctly, with correct link and link text. But no matter what I tried, in the import sheet, I couldn't extract the link value.</p> <p>I tried to do this via formulas and via scripting. I'm guessing the URL must be some sort of object but I cannot seem to read or split it. Whatever efforts I've tried have always returned the link text, EG Google, Yahoo and not the URL itself.</p>