Hi,

I wrote a script to run calculations on a certain website and collect the results as an XML data. Then same script copy that XML data and paste it to Excel. It copies thousands of lines but I only need the delimited ones.

Is there a way to write a macro to clean the XML data and leave the delimited ones only on the worksheet?

Thanks,