FILTERXML
Returns specific data from the XML content by using the specified XPath. This function is not available in Excel for the web.
Syntax
FILTERXML(xml, xpath)
Parameters
- xml: Required. A string in valid XML format
- xpath: Required. A string in standard XPath format
Example
=FILTERXML(A1, "//item[@type='book']/title")