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


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.


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.



Leave a Reply

Your email address will not be published. Required fields are marked *