Posts Tagged ‘ Paste Text ’

Macros to “Paste as Text” for Word and Excel

2017/11/07
By
Modified: 2017/11/05
Macros to “Paste as Text” for Word and Excel

These two macros will save you a lot of time.  They used, when you need to copy something from Internet page into a Word or Excel document, but  you do not need all the colors and formatting.   You just need the text. Usually you would do this with Paste Special, but this is several awkward clicks and many seconds lost.  Over the course of the day this is a huge inefficiency. Let’s write a macro for Word first. As of 2012-01-11 WED, I adopted this little macro as final version: Sub PasteText() On Error GoTo Unicode Selection.PasteSpecial Link:=False, DataType:=wdPasteText, _ Placement:=wdInLine, DisplayAsIcon:=False GoTo Done Unicode: Selection.PasteAndFormat (wdFormatPlainText) Done: End Sub This macro…

Read more »