I have a long list of jobs in Word. How can I copy each line
from Word into a seperate cell to form a column in Excel?

At the moment I'm copying and pasting each line individually,
which takes forever! Is there a way to copy and paste all the
data in one go into seperate cells for each Word line?

eg Word

Goto wholesaler
Wash dirty parts
contact suppliers

Excel

A
1 Goto wholesaler
2 Wash dirty parts
3 contact suppliers

Thanks!

It depends how your "lines" in Word are separated. If they merely flow from
one line to another because of the line width, then they won't be separated,
but if you've got lines separated by "returns" or paragraph marks, then if
you copy from Word to Excel they will normally be put into different cells.
--
David Biddulph

"Homer" wrote in message
...
I have a long list of jobs in Word. How can I copy each line
from Word into a seperate cell to form a column in Excel?

At the moment I'm copying and pasting each line individually,
which takes forever! Is there a way to copy and paste all the
data in one go into seperate cells for each Word line?

eg Word

Goto wholesaler
Wash dirty parts
contact suppliers

Excel

A
1 Goto wholesaler
2 Wash dirty parts
3 contact suppliers

Thanks!

If I open a Word doc, enter your three lines, block them, <Ctrl<C, goto
Excel and <Ctrl<V, I get line 1 in A1, line 2 in A2 and line 3 in A3?
--
Hth

Kassie Kasselman


"Homer" wrote:

I have a long list of jobs in Word. How can I copy each line
from Word into a seperate cell to form a column in Excel?

At the moment I'm copying and pasting each line individually,
which takes forever! Is there a way to copy and paste all the
data in one go into seperate cells for each Word line?

eg Word

Goto wholesaler
Wash dirty parts
contact suppliers

Excel

A
1 Goto wholesaler
2 Wash dirty parts
3 contact suppliers

Thanks!