Is there a program to capture text from MS Word tables into Excel? - questionnaire templates beer
I have 100s of questionnaires by e-mail me and I need a quick way to get data from Word tables into an Excel template for the analysis. (I know I should have insisted on questionnaires to Excel, but it's too late!) Thanks
Sunday, February 21, 2010
Questionnaire Templates Beer Is There A Program To Capture Text From MS Word Tables Into Excel?
1 comment:
Select the table you have created
Go to the Table menu-> Convert-> Table-> (text separated by commas), click OK
Now, the whole is transformed into a coma separated.
Copy and paste all the entries in the book
Save the file in Notepad as myfile.csv
when you save the icon will change into Excel.
Double-click ... and
Post a Comment