Hey everyone,



I've ran into this problem and can't seem to find an easy and fast solution. I have a large amount of data stored in table such as this:


I need to rewrite or convert it to a code where each data line would look like this:

<measure>
<observation-time>2011-02-10T00:15Z</observation-time>
<at>-4.5</at>
<td>-11</td>
<pi>1</pi>
<ws>1.7</ws>
<sc>33</sc>
<st>-3.3</st>
<sst>-0.9</sst>
</measure>

Any ideas how can I do this in an easy and fast way? I'm familiar with macros but I'm only at a beginner level.

I would really appreciate the help!

Hi niuri,

Since this is probably for output in text format, I'd suggest a Catalogue/Directory mailmerge in Word, with your Excel workbook as the data source. With that, you can easily add the relevant coding between the data fields. No macros required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi again,

I've never used this mail merge tool, can you explain a bit more? I can't understand how does it work

Edit: Never mind! I've figured it out myself. Thanks a lot for your help! You saved me a lot of time...