View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Homer Homer is offline
external usenet poster
 
Posts: 9
Default Copying data from Word

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!