ExcelBanter - XML Data

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - XML Data (https://www.excelbanter.com/excel-programming/436457-xml-data.html)

Is there any way to create a program to turn data I may be viewing as an xml
list in excel, to return a record where all attributes of the record are in
ONE record row. I have an xml file where the data many times is displayed
across several rows in excel. Trying to sort on the data then becomes
extrememly problematic. I would like to view the xml data in excel like I
could when importing a txt file. Is this possible using xml in excel?

On Nov 20, 3:03*pm, Jcraig713
wrote:
Is there any way to create a program to turn data I may be viewing as an xml
list in excel, to return a record where all attributes of the record are in
ONE record row. *I have an xml file where the data many times is displayed
across several rows in excel. *Trying to sort on the data then becomes
extrememly problematic. *I would like to view the xml data in excel like I
could when importing a txt file. *Is this possible using xml in excel?

try using the SPLIT function with < and or use MID while looping
through the text.
could you share some sample data?