creating multiple files with .xml extension using excel

[gmoorthy]

I have two columns in excel A and B

Column A has names like

Agent
City
Country


Column B has something like an XML file

</XML/Agent/Name>XXXXXX</XML/Agnet/name>
</Date>YYYMMDDD</Date>


Similarly for City column i have corresponding data in Column B


what i want is how can take each cell from columbn B and create another file which will be in notepad which will have the data from column B and the notepad file name should be like Agent.XML , City.XML , Country.XML

 

[SkipVought]

Hi,

Use Data > Text to columns... Delimited

For the first &last parse select do not import. Just import the second parsed column.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}