How to use the ENCODEURL function
Author: Oscar Cronquist Article last updated on April 12, 2018
The ENCODEURL function returns a URL-encoded string.
Formula in cell C3:
=ENCODEURL(B3)
Excel Function Syntax
ENCODEURL(text)
Arguments
| text | Required. The string to be URL encoded. |
Comments
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, […]
Functions in 'Web' category
The ENCODEURL function function is one of many functions in the 'Web' category.
Returns a URL-encoded string.
Extracts specific values from XML content by using the given xpath.
Gets data from a web service on the Internet or Intranet.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form