Word

Pasting as Unformatted Text

Ease of Use

Easy

Version tested with

 

Submitted by:

Anne Troy

Description:

Remove unwanted paragraph and other formatting that comes over when you copy from the web and paste into Word. 

Discussion:

Many people are frustrated because they copy from a web page and, when pasted into Word, get unwanted paragraph spacing and other formats. Using Edit-Paste special-Unformatted text makes the newly pasted text take on the paragraph formatting that is currently applied at the insertion point, which is usually the desired format. This little macro can speed up the process of using Edit-Paste special-Unformatted text. We show you how to add this macro to normal.dot so that you can use it in any Word document on your PC instead of having to copy the macro into all documents in which you wish to use it. 

Code:

instructions for use

			

Sub PasteSpec() Selection.PasteSpecial Link:=False, DataType:=wdPasteText End Sub

How to use:

  1. Open Word
  2. Hit Alt+F11 to get to the Visual Basic Editor (VBE)
  3. On the left, double-click Normal.dot (or it may say just "normal")
  4. From the menu, choose Insert-Module.
  5. Paste or type the code above into the code window at the right of the VBE
  6. Hit the Save diskette icon.
  7. Close the VBE.
  8. Go to Tools-Customize, and choose the Commands tab.
  9. Under Category, choose Macro, and on the right, click and drag "Paste Spec" up to your toolbar.
 

Test the code:

  1. Copy some text from the web.
  2. Hit the new toolbar button you just created.
 

Sample File:

No Attachment 

Approved by Anne Troy


This entry has been viewed 119 times.

Please read our Legal Information and Privacy Policy
Copyright @2004 - 2020 VBA Express