If you checked Existing Worksheet, select a cell where you want to put the data.On step 3 of 3, review all information is correct, make any necessary changes, then click Finish.On step 2 of 3, check the box next to the desired delimiters (space, comma, tab, etc.), then click Next.In the Text Import Wizard, on step 1 of 3, click Delimited, then click Next. Click the file name, and then click Import. 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 option.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.Microsoft Office 2016 and earlier versions 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |