#1
|
|||
|
|||
How to convert multiple xml data in xl column to xl data
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to convert data | unwantedoz | Excel Programming | 1 | 10-17-2015 05:28 AM |
Copy column 1 data into Column 3 | ShailShin | Word VBA | 1 | 06-18-2015 10:49 AM |
column of data referenced to multiple grids on another sheet | zorniac | Excel | 1 | 11-15-2013 10:19 PM |
Right-Aligning Data to a Column | sunnyside | Excel | 3 | 02-27-2012 01:25 AM |
data change how to convert to original | gsrikanth | Excel | 6 | 12-30-2011 08:01 AM |