Martin Hogg
Reputation: 41
importrange doesn´t bring the text with the hiperlink, only brings the text
In Google Sheets importrange doesn´t bring the text with the hiperlink, only brings the text, any advice? I read a post that explains how to extract the link. But I think its not my case how to resolve. Also I don´t see in the menus how to tell that cell is hiperlink. Any Advice?
Upvotes: 1
Views: 1104
Answers (1)
player0
Reputation: 1
unfortunately, google sheets importrange does not support hyperlinks. you will need to extract them in your source sheet and reconstruct them in your data sheet.
Upvotes: 2
Related Questions
- Why is this IMPORTRANGE formula not working?
- Why does IMPORTRANGE not import data from a formula?
- Using IMPORTRANGE to import from Excel file in Google Drive
- ImportRange Not Working Properly - Google Sheets
- Why is Google Sheets IMPORTRANGE not working?
- IMPORTRANGE: multiple hyperlinks within one cell, importing this cell data into another sheet and retaining separate clickable links
- IMPORTRANGE built dynamically, pulls in as string when it lands in cell instead of the formula
- How to import hyperlink URLs using IMPORT functions on Google Sheets?
- value(importrange()) not converting text into number
- After using importRange to get Hyperlinked cells, how do you get the value of the URL?