XML Data

  • Thread starter Thread starter Jcraig713
  • Start date Start date
J

Jcraig713

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?
 
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?
Click to expand...

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