Click a cell in your imported text file.
Click Edit Text Import on the External Data toolbar (toolbar: A bar with buttons and options that you can use to carry out commands. To display a toolbar, point to Toolbars on the View menu, and then click the toolbar you want. If the button you want doesn't appear, click More Buttons.).
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.