- text - The text to be encoded.
How to use
The ENCODEURL function returns a URL-encoded string composed of US-ASCII characters. URL encoding, sometimes called "percent encoding" is a method of encoding characters in a URL using only legal US-ASCII characters. Some characters cannot be part of a URL and are "reserved". Only characters that are reserved are encoded by ENCODEURL; other characters are left untouched. Common reserved characters include the space character (" "), the forward slash "/", the hash character (#) and others as shown in the example above.
To use ENCODEURL, supply text or a cell reference that contains text. In the example below, ENCODEURL is used to encode the text "Hello World!"
=ENCODEURL("Hello World!") // returns "Hello%20World%21"
In the example at the top of the page, the formula in cell C5, copied down is:
At each new row, ENCODEURL returns the encoded text from column B.
The table below shows a list of reserved characters and their url-encoded equivalent.