I have to copy and paste large amounts of text from a database program into Excel. If I just copy and paste it normally it separates the text into a bunch of different boxes on my Excel worksheet. So I have to do paste special everytime; which takes a lot more time. So how do I change the default Biff3 paste to Unicode so I don't have to do paste special every time? Any Excel buffs out there able to answer this one?