Doesn't anyone know how to set Unicode paste as default?

[rockthrowjoe]

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?

 

[NateO]

Why would PasteSpecial take so much longer?

You can add certain PasteSpecial buttons to your toolbar eh, I have done so as I use them a lot.

Otherwise, you'll probably want an import sub routine.

Edit: I like Dan's advice, Macro Recorder time?

 

[dk]

I believe there's a couple of 'Excel buffs' who frequent this board!

I don't think you can set the default for the Paste Special but you can easily create a simple macro that will paste special as Unicode. You could also assign a shortcut key to it to make it a quick operation. Here is the code that was created when I recorded this operation:-

Sub Macro1()

    ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
        DisplayAsIcon:=False
End Sub