Paste Text

[livetohike]

I often find the need to paste plain (un-formatted) text into a cell.

To avoid pasting the formatting I have to:
double-click (or F2) into the cell before I paste OR or Rght-Clk ->
Paste Special -> Text

Can I accomplish this w/ a single key stroke or toolbar click; i.e.
paste plain text into the active/current cell w/o having to be in
insert mode (F2).

I tried to record a macro, but it appears the clipboard is emptied
when you start recording because the Paste Special function is grayed
out.

Thanks

 

[Gary''s Student]

Say we make the following macro:

Sub oneshot()
ActiveCell.PasteSpecial Paste:=xlPasteValues
End Sub

and assign the shortcut CNTRL-e to it. Then:

1. pick a cell
2. copy with CNTRL-c
3. pick the destination
4. paste with CNTRL-e