copy attribute to closing tag

[karm4]

I have a huge xml file which I want to import into Excel. As part of this, I need the opening and closing tags to match. this is a snippet of what I am starting with:\[code\] <FIELD NAME="language">en</FIELD><FIELD NAME="languages"></FIELD><FIELD NAME="charset"></FIELD><FIELD NAME="urls"></FIELD>\[/code\]etcI need it to transform to this\[code\] <"language">en</"language"><"languages"></"languages"><"charset"></"charset"><"urls"></"urls">\[/code\]There is sometimes a number, sometimes a date, sometimes a URL and some times a ton of text in between the tags. can anyone suggest an approach? thanks