![]() Review each column of data to check the data format assigned by the wizard. Scroll through the data preview at the bottom of the wizard dialog box to verify that Excel correctly divides up the individual data fields on each line of your text file and make any necessary adjustments.Ĭlick on the "Next" button again to continue with step three. Activate the Comma check box in the list of delimiter choices. If you created the file yourself on Windows, select "Windows (ANSI)." If you're not sure of the encoding, check with the person who created the file.Ĭlick on the "Next" button to move on to step two of the import wizard. Set the "File Origin" drop-down menu to the correct text-encoding type. ![]() If it doesn't, click on the "Delimited" radio button. Verify that the wizard correctly identifies your data as delimited. You can choose a file on your local hard drive or select from a networked volume.Ĭlick on the "Import" button to bring up the Text Import Wizard. Locate your file in the Import Text File dialog box. In the Get External Data section, click on the "From Text" button. Select the "Data" tab from the Excel Ribbon.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |