Copying data from Word

H

Homer

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!
 
D

David Biddulph

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.
 
G

Guest

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?
 

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

using excel vba ope a word doc and copy-paste into another word doc 0
Copying Cell from Multiple Worksheets to a Summary Worksheet 4
Multiple Sheet copying 8
Copying cells from one spreadsheet to another? 7
Is there a character paste limit per cell? 4
How can I automate copying data from one into several spreadsheets 2
Comma delimiter 1
Need help with some data manipulation 3

Top