Format cells to paste as text only
Posted by Mark P on January 09, 2002 10:35 AM
I do a lot of cutting and pasting, often from other websites, and in order to convert my clipboard into regular text format, I often have to dump it into a blank Notepad and then re-copy it from there into Excel.
The Paste Special command generally works well for me, but I'd rather not have to use it every single time. Is there a way to configure a range of cells so that anything that gets pasted into them will be regular text (ie. Paste Special - Text)?
Mark
Posted by Russell Hauf on January 09, 2002 11:26 AM
You could paste the following into a module in your workbook. Then go to Tools-Macro-Macros, then click on Options and add a shortcut key to your macro (PasteText in the case below). Then copy your text from the internet, select the cell where you want the text to start, and hit your shortcut key (keys, actually).
Hope this helps,
Russell
Sub PasteText()ActiveSheet.PasteSpecial Format:="Text", Link:=
False, _
DisplayAsIcon:=False
End Sub
============================== I do a lot of cutting and pasting, often from other websites, and in order to convert my clipboard into regular text format, I often have to dump it into a blank Notepad and then re-copy it from there into Excel.
Posted by Namir on January 09, 2002 11:29 AM
Mark, why not just put a Paste:Values button on your toolbar? I have one right next to the regular paste button. Works as fast as regular paste!
-Namir
Posted by Mark P on January 09, 2002 11:37 AM
-Namir
Is there a hotkey for that, though?
Mark
Posted by Scott on January 09, 2002 11:41 AM
You could use Alt+S and then V. Or you could record a simple paste values macro, and assign a cntrl key. : -Namir
Posted by Scott on January 09, 2002 11:41 AM
You could use Alt+E and then S and then V. Or you could record a simple paste values macro, and assign a cntrl key. : -Namir
Posted by Scott on January 09, 2002 11:42 AM
Disregard... See next one up (NT)
