Friday, March 30, 2007

Hot key "Unformatted Text" in MS Word

Sometimes I like it when I paste things into MS Word and it retains all the formatting. Many times, I would rather it just paste it as unformatted text so I can make it merge with the rest of the doc.

Using MS-Word 2003, this is what I do so I can make Ctrl+Shift+V map to the Paste Special\Unformatted text.

Copy something off your browser with formatting.
MS-Word Tools\Macros\Record New Macro...
- Name macro PasteUnformatted
- Click the Assign Macro to Keyboard. Press Ctrl+Shift+V. Press Assign.
- Go to Edit\Paste Special. Choose Unformatted Text
- Click the Stop Button

View and/or edit the macro from the Tools\Macros\Macros... menu item
Select PasteUnformatted and click the edit button. It should look something like this.

Sub PasteUnformatted()
' PasteUnformatted Macro
' Macro recorded 3/30/2007 by Rich Alger
' this pastes the contents on the clipboard with no formatting
Selection.PasteAndFormat (wdFormatPlainText)
End Sub

See Paste Unformatted Macro

Once you are done you can use the Ctrl+Shift+V hot key to quickly paste in unformatted text.

UPDATE 2008-08-19
The last several times I had to do this, I always have to edit the macro and make sure it says wdFormatPlainText

UPDATE 2010-05-10
I was referring to this to get this to work in Outlook 2007. I just found that Ctrl+Alt+V brings up the "paste special" dialog box. You can arrow up and press enter. No need for a macro anymore. It works the same in Word 2007. "Alt, E, S" works in Word and Outlook 2003.

For other applications that do not have paste special you could use an application like PureText


Greg said...

For some reason, the "paste unformatted" was not hooked by Office XP, but by editing the macro to look like the one in this blog entry, everything worked out fine.

For someone who's never used macros before, this proved to be a useful bit of info!


Anonymous said...

Really helpful for me, I use Citrix for work but Word off my own drive, for speed. I'm always copying from work apps to my 'home' Word, and this is just what I needed - thanks - Tig.

Anonymous said...

You are a legend. Thank you so much. Not being able to hotkey an unformatted paste has been annoying me for 4 years.

Anonymous said...

You are a legend. Thank you so much. Not being able to hotkey and paste unformatted text has been annoying me for 4 years.

Rich Alger said...

"Legend" is a little much. This kind of post is the primary reason I blog. So I can remember months later how to configure my computer to fit _my_ needs.

Gabor said...

Unfortunately this was not woring for Office2007.
I found this on an other page and thjis works on Excel2007
Sub pastespecial()
Selection.pastespecial Link:=False, DataType:=wdPasteText, Placement:= _
wdInLine, DisplayAsIcon:=False
End Sub