Office Clipboard--from Excel to Word-- text only?

I

INTP74

It seems like I used to be able to do this...

I am copying data from Excel to Word using the office clipboard. I want to
paste text only into the Word document but I end up pasting the cell. How do
I paste text only from Excel to Word using the office clipboard? I am on
Office 2000 at this location but typically work on Office XP. Is this a
change from 2000 to XP or do i need to tweak some settings in 2000 to allow
this?
 
G

garfield-n-odie

Copy from Excel, switch to Word, and click on Edit | Paste
Special | Paste as: Unformatted Text.
 
I

INTP74

Right... that's how i would do it if I were not using the office clipboard.
But how would I accomplish this if I want to use the office clipboard? If I
use the Edit|Paste Special option it will past the last item on the office
clipboard in the format I want... but not the entire contents of the office
clipboard.
 
K

Keme

INTP74 said:
Right... that's how i would do it if I were not using the office clipboard.
But how would I accomplish this if I want to use the office clipboard? If I
use the Edit|Paste Special option it will past the last item on the office
clipboard in the format I want... but not the entire contents of the office
clipboard.

I cannot verify this right now, but it's worth a try. If copying single
cells, try copying the contents of each cell instead of the entire cell
oject:
Select the cell, enter edit mode (F2), mark the contents and copy to the
clipboard.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top