hotkey combo for "paste special, text only"?

  • Thread starter Thread starter abbyw
  • Start date Start date
A

abbyw

Hi

I regularly need to paste stuff copied from web pages (receipt number
are a good example, as are prices) into excel docs. That copy alway
seems to include formatting, so if I use a simple CTRL V to paste int
and excel cell, the formatting from the page is inserted as well.

I really want it to paste just clear text.

Before I learned about the "paste special" command, I used to hav
notepad open all the time, and paste the stuff there, select soethin
else and copy it, just to clear the buffer, select the text I wante
again, and paste it into excel - no formatting makes it thru tha
arduous process!

Ironically, that's almost faster than doing a "paste special", as it'
all keyboard based!

Help?

Thanks!

abb
 
If you customize toolbars, then select Edit commands,
there is a button for Paste Values. You can drag that
button to one of your toolbars and then just click the
button. I don't remember if that was available in XL97,
so if the button isn't available you could do the same
thing with a macro.
 
Back
Top