ENCODEURL function

Encodes 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.
Was this helpful?
How can we improve it?