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

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

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

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:

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

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

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

- Press Enter -> return value is:

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

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

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

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

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

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

Good luck!

5 ★ | 1 Vote

May be interested