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.
The pwrFORMATXML PowerUp function has the following arguments:
value – Required. This is the XML on which to apply the basic formatting.
pwrFORMATXML will return the original XML with basic indentation to help show the structure of the XML file.
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.