Note: The other languages of the website are Google-translated. Back to English

Excel ENCODEURL Function

The ENCODEURL Function converts a text to a URL-encoded string.

encodeurl-function 1


Syntax

=ENCODEURL(text)


Arguments

  • Text (required):Required. A text string to be URL encoded.

Return Value

The ENCODEURL function returns a URL-encoded string.


Function notes

  1. The ENCODEURL function is introduced in Excel 2013. Therefore, it is unavailable in earlier Excel versions. And it is not available in Excel for the web or Excel for Mac, either.
  2. The ENCODEURL function may appear in Excel for Mac's library, but it doesn’t return results on Mac because it relies on Windows operating system functionality.
  3. In the table below displays a list of certain non-alphanumeric characters and their URL-encoded equivalent.
    encodeurl-function 2

Example

As the below screenshot shows, there is a list of URL text strings. To convert them to URL-encoded string, please do as follows.

1. Please copy the formula below into cell D5, then press the Enter key to get the result.

=ENCODEURL(B5)

2. Select this result cell and drag its autofill handle down to get the rest of the results.

encodeurl-function 3

Note: We can also directly input a value in the formula. For example, the formula in cell D5 can be changed to:

=ENCODEURL("https://www.extendoffice.com/")

Relative Functions:

  • Excel EVEN Function
    The EVEN function rounds numbers away from zero to the nearest even integer.

  • Excel EXP Function
    The EXP function returns the result of the constant e raised to the nth power.

 

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL