Please Note: This article is written for users of the following Microsoft Word versions: 2007 and 2010. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Processing Information Pasted from a PDF File.
by Allen Wyatt
(last updated March 30, 2015)
Zach is constantly pasting quotes from PDF files into the body of his Word documents. He'd like to have a macro specifically for pasting from PDF that pastes without any formatting and automatically removes the paragraph breaks that are at the end of each line of the pasted text.
It is relatively easy to work with text in this manner in a macro. All you need to do is move the information from the Clipboard to a string variable. Once it is in the variable, there is no longer any formatting associated with the text and you can search for and replace the paragraph breaks. The following macro performs both steps:
Sub PastePDFClean() Dim MyData As DataObject Dim sTextIn As String Dim x As Integer Dim y As Integer Set MyData = New DataObject MyData.GetFromClipboard sTextIn = MyData.GetText x = InStr(sTextIn, vbCr) y = 1 While x > 0 sTextIn = Left(sTextIn, x - 1) & Mid(sTextIn, x + 1) y = x + 1 x = InStr(y, sTextIn, vbCr) Wend Selection.TypeText sTextIn Set MyData = Nothing End Sub
Remember; the macro works on whatever is in the Clipboard. So, in order to run the macro properly on a PDF selection, you need to copy the selection to the Clipboard and switch to your Word document before you run the macro.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (11626) applies to Microsoft Word 2007 and 2010. You can find a version of this tip for the older menu interface of Word here: Processing Information Pasted from a PDF File.
Do More in Less Time! Are you ready to harness the full power of Word 2013 to create professional documents? In this comprehensive guide you'll learn the skills and techniques for efficiently building the documents you need for your professional and your personal life. Check out Word 2013 In Depth today!
Do you want Word to always capitalize the first letter appearing after a colon? The program won't do it by default, but ...Discover More
When you need to perform certain editing tasks over and over again, you start to look for ways to make your work faster ...Discover More
Want to add a finishing touch to your printed document? Hyphenating the words in the document can make your text read ...Discover More
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.