An odd question maybe ?

G

Guest

Hi,

I want to steal some data that's in a Excel spreadsheet in 23 cells and copy
just the data in to MS Word. I don't want to import the whole table with
it's cells ...I just want the value in the cell.

If I do it one at a time it works and then its just a line of text in Word,
but if I try to copy more than one line into word it creates a table, how can
I avoid that, other then cut & pasting each cell one at a time?

Cheers'
Dave
 
T

Trevor Shuttleworth

Select all the cells and copy them.

In Word, PasteSpecial | Unformatted Text .... should give you the values tab
separated

Regards

Trevor
 

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

Similar Threads

copying/pasting accurately from a Word table (carriage returns) 1
Automatically skipping cells when pasting data 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Copy & Paste 2
how do i copy an excel spreadsheet into word document with a table 1
Copying a table from Word 5
How to merge cells vertically - and keep all data 0

Top