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?