Thanks to all those who replied with different ideas for solving
my mailing list problem.
It turns out that the easiest solution I got was to use a macro
included in the macro library. You have to load the file FLATFILE.XLA.
That creates the command DATA | SMARTPARSE in the command bar. You
simply select that command and enter the seperator character and it does
the rest for you.
For doing something which I didn't think was possible this
solution worked really well. Saved me the work of re-typing 5000 addresses.
Thanks again for all replies.