Hi all

I am hoping someone can help with a macro to do the following.....

I have my data in in this format:

Date FX Rate Conv Code
30/10/2013 1.1681 EUR
29/10/2013 1.1717 EUR
28/10/2013 1.1711 EUR

I need to take each row in the file and convert into this format.

DC
C
EUR
30102013
<>
<>
/
1.1681
<>
<>
<>
<>
DC
C
EUR
29102013
<>
<>
/
1.1717
<>
<>
<>
<>
DC
C
EUR
28102013
<>
<>
/
1.1711
<>
<>
<>
<>