ENCODEURL functionEncodes text so it can be used in the query string of a URL.
Parts of an ENCODEURL function
ENCODEURL(text)
Part
Description
text
The text to be encoded as a URL.
Sample formulas
ENCODEURL(“hello world!”)
ENCODEURL(A10)
Notes
This function is useful for passing in URL arguments to functions that make web requests, like IMPORTHTML.
Examples
Encode the text “hello, world!” into a URL-friendly format.
A
B
1
Formula
Result
2
=ENCODEURL(“hello, world!”)
hello%2C%20world%21
Use ENCODEURL to create a hyperlink.
A
B
1
Formula
Result
2
=HYPERLINK(“http://google.com?q=” & ENCODEURL(“hello world”))
http://google.com?q=hello%20world
Related functions
IMPORTHTML: Imports data from a table or list within an HTML page.
CLEAN: Returns the text with the non-printable ASCII characters removed.
REPLACE: Replaces part of a text string with a different text string.