I have a function which returns a URL from hyperlink as a first parameter to IMPORTXML function.

For the function to work I need to put the output of that function in quotes, how do I do it?


1 Answer 1


As pnuts said, you don't need quote marks there. Think of them as a container we have to use to separate our text from formulas, as in = "not" & B3, so that the string is recognized as such. If the text comes from a formula, it is already known to be text.

That said, if you actually had to put quotes around formula output, that would be done with

"""" & linkURL(A2) & """"

The rule is that quote marks " inside a string must be doubled. So, """" is a string with a single character ", and ="""" & A2 & """" outputs "url" if the cell A2 contains url.

Your Answer

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

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