importexcel

=Excel 2000 Intermediate=

If you have files from an outside source, you can import them into Excel, providing you have a way of distinguishing one column of data from another. When you go to the File|Open menu, you can change the Files of Type at the bottom to a Text file or other types of files. When you choose the file you want, Excel will take you through the Text Import Wizard. Step 1 of the Wizard will let you decide if the file is DELIMITED or FIXED WIDTH. If it is delimited, there would be a character (such as a space, comma, or tab) separating one column from the next. If it is fixed width, spaces were used to line up the columns. If you had chosen delimited, this is what Step 2 of the Wizard would look like. You would then choose the character that indicates a separation between one column and another. If you wish, you can treat consecutive delimiters as one. If this were fixed width, you would click in the data area at the exact spot(s) where you'd want the column splits to be. In step 3 of the Wizard, you can format the data in each column if you desire. You can even choose not to import a particular column.
 * || ===Importing Files into Excel===