Importing
Files into Excel
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.
|
