The information in this article applies to:
SUMMARYWhen you import text files into Microsoft Excel, the Text Import Wizard may automatically appear and display the first line as shown using the default parse line. You can bypass the Text Import Wizard and accept the defaults by holding down the SHIFT key when you open the file. MORE INFORMATIONIf the files you import into Microsoft Excel are always parsed correctly when you open them, you may not want to display the Text Import Wizard during the import process. To keep the Text Import Wizard dialog box from appearing when you import a file, follow these steps:
NOTE: The Text Import Wizard is not displayed when you open text files with a .CSV extension (comma-separated value files). Instead, the text file is parsed into separate columns using commas as delimiters. If you want the Text Import Wizard to be displayed for files with a .CSV extension, rename the text file so that its file name extension is .txt. REFERENCESFor more information about importing text files, click the Search button in Help and type: TextWizardFor more information about importing files, see Chapter 42 of the "User's Guide." Additional query words: 5.00a 5.00c 7.00a 8.00 97 XL97
Keywords : kbdta kbconversion xlloadsave xlwiz |
Last Reviewed: October 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |