I thouight I had posted this but if so it's somewhere obscure so I'm
trying again!

I have a large number of addresses I need tyo get into a manageable
format i.e. useable email addresses, a latge proportion are formatted
like this: 'familiarname!someones@somewhere. If I copy no matter
what I do it will only paste the familiar name, the address is lost. I
have tried every combination I cam think of. I have about 800
addresses and it would be aweful if I have to manually edit them.

Any ideas?

thanks