How can I allways paste PLAIN TEXT ?

E

Earl Kiosterud

Davus,

Edit (or right-click) - Paste special - Values. A macro can speed thing up
by allowing you to use a keystroke or button.
 
J

John Mansfield

Activate the cell with the text that you want to copy. Go to Edit -> Copy
Edit -> Paste Special -> Values. This assumes that your text is not tied to
formulas. If so, this method will overwrite the formula by copying the text
returned by the formula as a value.
 
Top