The imported information is now in the correct format in Excel. If any information isn't correct, make any necessary changes and click Load. Verify the default information is correct and click Load. Excel opens a blank pop-up box asking you to specify the File Origin, Delimiter, and Data Type detection.Find the location on the computer where you saved the plain text file in step 3.In the Ribbon, click the Data tab, and click the From Text/CSV option.Open Microsoft Excel and click New > Blank workbook.You can now close the Word document and program.Leave the Windows (default) checked, and click OK. A File Conversion pop-up window opens.For this example, the Word file is named "CH Test File," and the plain text file is named "CH Test File Plain." Once you've chosen the location and named the file, click Save. Choose the location on your computer where you want to save the plain text file, enter a name for the file, and change the file type to Plain Text.In the Ribbon, click the File tab, and click the Save As option.Open the Word document containing the information you want to convert to Excel.Microsoft Office 2016 and earlier versions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |