Excel 2007 : Default Unicode

[camp0433]

I'm copying and pasting a lot of addresses from the Internet into Excel and having to Paste Special, Unicode text every time.

Is there a way to have 'Unicode' applied to the default pasting option in Excel so I don't have to go into special options?

[CirtexHosting]

You copy not only text or something like that but also style etc. I think that better use notepad as intervening buffer.