Clear, practical technology insights About · Contact

ENCODEURL function - The function returns a query string with URL code in Excel

ENCODEURL function: The function returns a query string with the URL code. Support functions from Excel 2013 onwards. Syntax: ENCODEURL (text)

Author: David Pac2 minutes read

The following article introduces you to the ENCODEURL function - one of the functions in the Web function group is very popular in Excel.

images 1 of ENCODEURL function - The function returns a query string with URL code in Excel

Description: The function returns a query string with the URL code. Support functions from Excel 2013 onwards.

Syntax: ENCODEURL (text)

Inside:

- text: A string requires URL encoding, which is a required parameter.

Attention:

- If text is not a URL string -> the function still encodes as URL string.

For example:

Encode the URL strings described in the following data table:

images 1 of ENCODEURL function - The function returns a query string with URL code in Excel ;

- In the cell to calculate enter the formula: = ENCODEURL (C6)

images 1 of ENCODEURL function - The function returns a query string with URL code in Excel

- Press Enter -> return value is:

images 1 of ENCODEURL function - The function returns a query string with URL code in Excel

- Similarly copying the formula for the remaining values ​​results:

images 1 of ENCODEURL function - The function returns a query string with URL code in Excel

- Where the text value is not the URL string -> the function is still encoded as the URL string :

images 1 of ENCODEURL function - The function returns a query string with URL code in Excel

Above are instructions and some specific examples when using ENCODEURL function in Excel.

Good luck!

Was this article helpful?

Your feedback helps us improve.

Discussion

Reader Comments 0

Sign in with email or Google to join the discussion.