From word to excel

[Guest]

Does anyone know how or if it possible to transfer from word document to
excel sheet. I have a list of items and discriptions on a word sheet that i
need to put into excel so that costs can put to them. If i copy and
paste,excel puts the discription onto seperate lines instead of merging into
cells. if i try to merge the lines it onlyuses the top line and deletes the
other lines. i cant use a formula as it wont have the original info to refer
back to. Do i really have to cut and paste each seperate line into the right
cell? If that makes sense to anyone please help

 

[Guest]

The trick is how you paste.

The usual method:
click in a cell and then touch CNTRL-v

The trick:
click in a cell, then click in the formula bar and then touch CNTRL-v

 

[Guest]

Thank you , i do use the cntrl-v in the formula page its just as there is
over 30 pages of this do its going to keep me busy for some time . I was just
wondering if there was a quicker method as its nearly quicker to just type
the whole thing out into excel from the begining.

 

[Dave Peterson]

If the data in the MSWord document is formatted as a table, then maybe you can
use this (saved from a previous post):

If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.

One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.

I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)
Find what: (paragraph mark under Special button)
replace with: $$$$$ (if $$$$$ doesn't appear in the table)
replace all

Same thing with Manual Line break (from under Special).

Now copy the table into Excel.

Edit|Replace
Replace what: $$$$$
Replace with: ctrl-j (hit and hold the control key and hit j)
replace all.

You may have to use Format|cells|Alignment tab|check wrap text

Don't forget to close the word document without saving (or hit undo as many
times as necessary).

=========
If the data in the MSWord document isn't a table, maybe you can create a table
in MSWord--or use the same technique for each paragraph that you need to
copy|paste???

 

[MartinW]

Hi Karen,

It depends on how your Word document is formatted but
try this slowly at first.
Copy your entire first page in word then in Excel, select A1
and Edit>Paste Special and select Text from the options list,
if that works but not quite then you may have to look at
copying it piece by piece. On the other hand if it works
out have a go at all 30 pages.

HTH
Martin

 

[Guest]

Brillaint - amazing how you can learn so much from one question . Thank you