ID EN
#Web

ENCODEURL

Excel Functions

Get URL-encoded string

Syntax

EXCEL
=ENCODEURL(text)

Arguments

Parameter Description
text The text to be encoded.

Return Value

Encoded text

Details

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!" 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 f

Examples

Example

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!"

EXCEL
=ENCODEURL("Hello World!") // returns "Hello%20World%21"
Example

In the example at the top of the page, the formula in cell C5, copied down is:

EXCEL
=ENCODEURL(B5)

See Also

WEBSERVICE FILTERXML