| Syntax |
| =ENCODEURL(text) |
| Purpose / Description |
| Returns an encoded URL in which punctuation and other non alpha-numeric characters are replaced with hexadecimal encoded characters, for example a space is replaced with its hex code %20. |
| Arguments |
| Name |
Type |
Description |
| text |
text string |
A reference to a range or nested expression that returns a valid reference, a constant or a nested expression that derives the value to be used as the source URL to be encoded. Numbers and logical values will be coerced to text. |
| Return Values |
| Type |
Specific Value |
Description |
| text string |
|
Returns the encoded URL in which the non-alphanumeric are replaced with hex encoded characters. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Warning: |
This function relies on Windows operating system functionality, and so only returns valid results on the Windows desktop. It is not available in the web versions of Excel, and although it may appear in the function gallery in MacOS, it does not return a value. |
| Examples: |
Open / download sample workbook that covers the basics for this function: ENCODEURL, WEBSERVICE.xlsx |
| |