Article updated on April 12, 2018

The ENCODEURL function returns a URL-encoded string.

Formula in cell C3:


Excel Function Syntax



text Required. The string to be URL encoded.


URLs sent over the internet use the ASCII character set. Characters outside the ASCII set must be converted into a valid format.

Space characters are translated into %20 and unsafe ASCII characters with a "%" followed by two hexadecimal digits.

How to use the DEC2HEX function

The DEC2HEX function converts a decimal number to a hexadecimal number. Formula in cell D3: =DEC2HEX(B3,C3) Excel Function Syntax DEC2HEX(number, […]