Solved

Convert a Word file with figures to Excel

Posted on 2011-03-02
6
212 Views
Last Modified: 2012-05-11
Dear All

Is there a piece of software that easily converts a word file with lots of figures to Excel please?

Thanks
0
Comment
Question by:lloydabberton
  • 4
6 Comments
 
LVL 10

Expert Comment

by:cdebel
ID: 35016771
Have you tried to only select all your pages (CTRL-A), and do a copy paste into excel?

Because with Office 2010, everything seems to be copied...  and between 2007 and 2010 there must not be so much difference.  Give it a try
0
 
LVL 10

Expert Comment

by:cdebel
ID: 35016805
There's also a program named "File Conversion Wizard for Word and Excel" who claim to do what you are asking for, but i've never tried it.

Here's a link to download it
0
 
LVL 31

Expert Comment

by:Paul Sauvé
ID: 35021119
Hi Lloyd,

When you CUT & PASTE from Word to Excel, it works if your Word data is in a table, otherwise you get one cell of Excel for each line in Word.

PaulS
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 76

Expert Comment

by:GrahamSkan
ID: 35021516
It would help if you were to post a sample document.
0
 
LVL 10

Expert Comment

by:cdebel
ID: 35021689
@Paul: Wrong.  With Word & Excel 2010, you can copy data from Word and paste it in Excel 2010, and your data is not placed all in a single cell as you say.

I write: "Hello" ... then 2 lines bellow "World".  I copy everything to the clip board, do a paste into excel and on line 1 i got "Hello", and line 3 "World".
0
 
LVL 10

Accepted Solution

by:
cdebel earned 250 total points
ID: 35021705
Well, maybe not wrong...   since he posted that in Word 2007.  Sorry for that.   But it work perfectly in 2010.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing. A Range prope…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now