To use ENCODEURL, supply text or a cell reference that contains text. In the example below, ENCODEURL is used to encode the text “Hello World!” In the example at the top of the page, the formula in cell C5, copied down is: At each new row, ENCODEURL returns the encoded text from column B. 

Reserved characters

The table below shows a list of reserved characters and their url-encoded equivalent.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.