Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Word Training and help » microsoft word training courses london - Word form data for use in Excel
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft word training courses london - Word form data for use in Excel
Resolved · Low Priority · Version Standard
Reply
Word form data for use in Excel
I have created a form in Word which I will have completed by a number of respondents. I would like to export the responses into Excel for analysis in a table format. When I try and save it as a .txt file as instructed in the Help menu however, the data does not show up properly. There are a series of speech marks and comas around the responses. also when the information is copied into excel it all appears in one cell. Is there a way for me to overcome this? I believe its the text encoding option I am using that's not write but I can't figure outwhich the right one should be. Look forward to hearing from you and thanks in advance.For upcoming training course dates see: Pricing & availability
RE: Word form data for use in Excel
Hi SariatThanks for your question.
When you open the text file inside Excel, an import wizard should come up on your screen. You should be able to choose the Delimited option at step 1 of the wizard, then at step 2 you can select what it is that is separating the columns of information from each other. If you are not sure what is separating the columns, then you can try ticking each of the boxes under 'Delimiters' one at a time and look at the preview underneath to see if the information is displaying in columns.
If none of the delimiter options split the information into columns, then you may need to try reformatting the information in the Word document so that you can control what information appears in which columns. You can use any of the delimiters (tab, space, comma, semi colon) to separate pieces of information into the columns you wish to use in Excel.
I hope this helps.
Amanda
|
 |
|
» Forum post: MS Project Security |
Is it possible to have different levels of security within your Resource Pool Sheet, i.e. a level for managers and a level for admin staff?
