ENCODEURL Formula in Excel

The ENCODEURL formula in Excel returns a URL encoded string by replacing certain non-alphanumeric characters with percentage symbol and hexadecimal number. The ENCODEURL formula in Excel is a part of web formulas.

The ENCODEURL formula in Excel is used to return a URL encoded string. In Microsoft Excel ENCODEURL formula, certain characters cannot be a part of a URL encoded string and those are replaced by the percentage symbols and hexadecimal numbers. The remaining characters are not replaced and kept as it is.

The ENCODEURL formula is available in Excel 2013 and all subsequent versions on Windows. The ENCODEURL formula is not available in Excel for Mac and web. Even though you may find the ENCODEURL in Mac under formulas, still it will not return the result as it relies on Windows operating system.

How to use the ENCODEURL Formula in Excel?

The article in this webpage describes how to use ENCODEURL formula in Excel with syntax, detailed explanation, and examples.

ENCODEURL Syntax

=ENCODEURL(text)

The argument of ENCODEURL formula is:

• Text (required argument) – a text string.

ENCODEURL Examples

Example 1

Let’s understand the ENCODEURL formula in Excel with example.

In the below example of ENCODEURL formula in cell B6, the text argument “Rath Point” contains one space between the two words which is replaced by %20.

=ENCODEURL(“Rath Point”)

Example 2

Let’s take another Excel ENCODEURL formula example with multiple non-alphanumeric characters and find out how it works.

In the below example of Excel ENCODEURL formula in cell B6:

• : is replaced by %3A,
• / is replaced by %2F (2 times), and
• . is not replaced and left as it is.

=ENCODEURL(“https://rathpoint.com”)

Important Notes

You must remember the below key points while using the ENCODEURL formula in Excel:

• The ENCODEURL formula is available in Excel 2013 and next versions in Windows.
• The ENCODEURL formula is not available in Excel for Mac or web users.
• The URL encoded string for the characters are: