ENCODEURL function
Summary
Returns a URL-encoded string This function is not available in Excel for the web.
Syntax
ENCODEURL(text)
The ENCODEURL function syntax has the following argument.
Text Required | A string to be URL encoded
Text Required | A string to be URL encoded
Example
=ENCODEURL("http://contoso.sharepoint.com/Finance/Profit and Loss Statement.xlsx")
=WEBSERVICE("http://dev.markitondemand.com/MODApis/Api/Quote/xml?symbol="&ENCODEURL(C2))
=FILTERXML(WEBSERVICE("http://dev.markitondemand.com/MODApis/Api/Quote/xml?symbol="&ENCODEURL(C2)),"//QuoteApiModel/Data/LastPrice")
=WEBSERVICE("http://dev.markitondemand.com/MODApis/Api/Quote/xml?symbol="&ENCODEURL(C2))
=FILTERXML(WEBSERVICE("http://dev.markitondemand.com/MODApis/Api/Quote/xml?symbol="&ENCODEURL(C2)),"//QuoteApiModel/Data/LastPrice")