PowerUp Description
The pwrFORMATXML PowerUp function applies basic formatting (indentation) to the provided XML input. This may be helpful in viewing the structure of XML from a number of sources including a Web Service.
PowerUp Syntax
pwrFORMATXML(value)
The pwrFORMATXML PowerUp function has the following arguments:
value – Required. This is the XML on which to apply the basic formatting.
Return Value
pwrFORMATXML will return the original XML with basic indentation to help show the structure of the XML file.
Remarks
In order to see the indentation in Excel, you must apply the Wrap Text function to the cell with formatted XML to see the added line breaks.
Example
=pwrFORMATXML(A1)
