The ENCODEURL function returns a URL-encoded string.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.
  • This function is not available in Excel Online, and it is not available in Excel 2016 for Mac.

Syntax

=ENCODEURL(text)

Arguments

Argument Description
text A string to be URL encoded

Examples

  A B B C
1 XML Response   ZIP   
2 =WEBSERVICE(“http://xml.weather.yahoo.com/forecastrss/”&ENCODEURL(C2)&”_f.xml”) 98052  
3        
4 Place: =FILTERXML(A2,”//yweather:location/@city”) =FILTERXML(A2,”//yweather:location/@region”)  
5 Current conditions: =FILTERXML(A2,”//yweather:condition/@temp”) =FILTERXML(A2,”//yweather:condition/@text”)  
6 Forecast: =FILTERXML(A2,”//yweather:forecast/@day”) =FILTERXML(A2,”//yweather:forecast/@text”)  
7        
8 Description      
9 This example uses the ENCODEURL function to pass the zip code in cell C2 as a parameter to the web query in A2. The FILTERXML function is used on the web query to return city and state information, and current and projected weather conditions for that zip code in cells B4:C8.