For example I have a sheet and there is a col with cell-like A2 and A2 has a hyperlink. A2 value is 'Apple' and the hyperlink is 'stackexchange.com'.

When I am trying to use importrange formula with A2 cell, the cell value+hyperlink, both imported.

How do I import the cell value only which is 'Apple'?

=IMPORTRANGE("url", "sheet1!A2")
  • Can anyone answer it?
    – Jebra
    Commented Aug 13, 2022 at 9:23
  • it is not possible to give a precise answer to a vague question ... do your best to explain the problem, for example cell A2 what exactly contains and why you want to import all column A. .. and if you also tell us what is the URL
    – Daniele
    Commented Aug 13, 2022 at 10:44
  • @Daniele, question updated. A2 has value = 'Apple' and hyperlink = stackexchange.com I want to import the A2 to another spreadsheet with value only as 'Apple'.
    – Jebra
    Commented Aug 13, 2022 at 19:10

1 Answer 1


I believe this formula solves your problem:

=T(IMPORTRANGE("url", "sheet1!A2"))

( a simple T placed in front of your formula ).

Sometimes the underline of the text will remain, which you can delete with the key combination CTRL + \

  • It does not work on the range. but work on a single range. Like not work this mode: =T(IMPORTRANGE("url", "sheet1!A2:A10")), this way not import anything.
    – Jebra
    Commented Aug 14, 2022 at 9:18
  • if you want to use this type of formula in a range of multiple cells use: INDEX(T(IMPORTRANGE("url", "sheet1!A2:A10")))
    – Daniele
    Commented Aug 14, 2022 at 11:02
  • Perfect!!!!! <3
    – Jebra
    Commented Aug 14, 2022 at 11:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.