Exceljet

Quick, clean, and to the point

Excel ENCODEURL Function

Excel ENCODEURL function
Summary 

The Excel ENCODEURL function returns a URL-encoded string composed of US-ASCII characters. ENCODEURL is only available in Excel 2013 and later on Windows.

Purpose 
Get URL-encoded string
Return value 
Encoded text
Syntax 
=ENCODEURL (text)
Arguments 
  • text - The text to be encoded.
Version 
Usage notes 

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.

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

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

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 from column B. 

Reserved characters

The table below shows a list of reserved characters and their url-encoded equivalent.

Character Encoding
! %21
# %23
$ %24
% %25
& %26
' %27
( %28
) %29
* %2A
+ %2B
, %2C
/ %2F
: %3A
; %3B
= %3D
? %3F
@ %40
[ %5B
] %5D
  %20

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas