Turn on the macro recorder by selecting Tools, Macros, Record New Macro from the main menu. From the File menu, select Open. Change the Files of Type to All Files and find your text file.

In the Text Import Wizard's Step 1, specify that the data is Fixed Width and click Next.

Excel then looks at your data and attempts to figure out where each field begins and ends. Figure 18.2 shows Excel's guess on this particular file. Because the Date field is too close to the Customer field, Excel missed drawing that line.

0 0

Post a comment