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
| Row | A |
|---|---|
| 6 | Code |
| 7 | A B |
| 8 | A+B |
| 9 | A/B |
Record 1
=ENCODEURL(A7)Illustrative outputA%20B
See the inputs and instructions for all 3 examplesCopyable 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 |