microsoft word training courses london - Word form data for use in Excel

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