I had to create a report for the sales. I was not much familiar with the Excel, so I used Word instead. I want to convert my Word file to Excel spreadsheet. How can I achieve this?
You can change it to Excel spreadsheet directly on the PC.
• Open the Word file
• Click on File->Save As.
• Select plain text (.txt) in the drop down list of Save as Type field. Click Save->OK to close file
conversion dialog box.
• Now open the Excel spreadsheet.
• Click on Data->From Text.
• Select your file which you have just saved. Click Import.
• A dialog box named Text Import Wizard appears. Choose ‘Delimited’ and click next.
• In next step, mark the delimiters you need. (Delimiters are the characters that separate each field)
• Select data format in Step 3. Click Finish.
• Select Existing worksheet in the next dialog box.
• Save your document.
