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!