Change how an imported text file looks
-
Click a cell in your imported text file.
-
Click Edit Text Import
on the External Data
toolbar. -
Click Import in the Import Text File dialog box.
-
Make changes to the imported text file in the Text Import Wizard, and then click Finish.