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.

Hi Sariat

Thanks 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