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.
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!”
Reserved characters
The table below shows a list of reserved characters and their url-encoded equivalent.
Related functions
WEBSERVICE Function
The Excel WEBSERVICE function returns data from a web service.
The WEBSERVICE function is only available in Excel 2013 and later for Windows.
FILTERXML Function
The Excel FILTERXML function returns specific data from XML text using the specified XPath expression.
