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]
|