XML to Excel
 

We have an application using SQL. In one of the field in SQL table, it's XML
coding combining multiple fields. something like this --
<?xml version="1.0" encoding="ISO-8859-15"?<ItemInfo<row addr1 = "5100
Springfield Street, Suite 210" city = "Dayton" fname = "Emily" format = ""
formattext = "" lname = "Abell" state = "OH" suffix = "" title1 = "Associate
Software Engineer" title2 = "Adroit C4ISR Center" zip = "45431" /</ItemInfo

How do convert this whole string into separate fields in Excel?

Thanks.