TextLevel: ExpertAvailable in: Excel 2013+
In this article
- Syntax
- Examples
- Example 1
- Related functions
FILTERXML extracts values from XML with an XPath. Its famous side use: splitting text in versions without TEXTSPLIT.
Syntax
=FILTERXML(xml, xpath)
| Argument |
What it means |
xpath |
e.g. “//item/price”. |
Examples
Example 1
=FILTERXML("<t><s>"&SUBSTITUTE(A2,",","</s><s>")&"</s></t>", "//s")
Split a comma list into cells in Excel 2016/2019.
WEBSERVICE · TEXTSPLIT
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong