ExcelFlux

ENCODEURL function

a URL-encoded stringThis function is not available in Excel for the web.

Web · Excel 2013+ · Guided Excel example

Where can you use it?

Teams bringing external data into Excel. Check the connection and Excel platform required by the example when a report depends on a URL or other external data.

Scenario in the workbook

Encode spaces, plus signs and slashes distinctly in URL parameters.

A worked example from the workbook

RowA
6Code
7A B
8A+B
9A/B
Record 1
=ENCODEURL(A7)

Illustrative outputA%20B

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=ENCODEURL("A B")
Turkish Excel · tr-TR
=ENCODEURL("A B")

Expected result

“A%20B”

Worked examples

Encode spaces, plus signs and slashes distinctly in URL parameters.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Code
7 A B
8 A+B
9 A/B
Trial Expression Sample output
Record 1 =ENCODEURL(A7) A%20B
Record 2 =ENCODEURL(A8) A%2BB
Record 3 =ENCODEURL(A9) A%2FB
Microsoft Excel reference