Hi,

I need an help on converting xml data to xl, I have multiple xml data available in one of the column of my excel sheet and want to convert this xml data from each cell of column to excel data and append this data in separate sheet.

E.g.

Col A Col B
1 <xml></xml>
2 <xml></xml>
3 <xml></xml>

Want to convert above into single xl data and data as follows

Col A Col B Col C
1 xml1 converted to xl data abc1
2 xml1 converted to xl data abc2
3 xml1 converted to xl data abc3

Regards,
Vivek