Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Importing Text File to Excel
0 views
Skip to first unread message
Matthew MacCarthy
Oct 11, 2003, 1:51:22 PM10/11/03
to
How is it possible to import data from a text file into
Excel so that each data element is contained in its own
cell, instead of an entire line of the text data being in
one cell?
Excel so that each data element is contained in its own
cell, instead of an entire line of the text data being in
one cell?
Dave Peterson
Oct 11, 2003, 2:00:25 PM10/11/03
to
When I open a text file (like *.txt), I get a wizard that'll help me parse each
line into separate cells in each row.
line into separate cells in each row.
If each element (not sure what that means) is separated by a space character,
I'd select delimited when that wizard asked me to choose between "fixed width"
and "delimited". Then the next step prompts me for the delimiter.
This is pretty standard. But something else must be happening for you?????
--
Dave Peterson
ec3...@msn.com
Debra Dalgleish
Oct 11, 2003, 2:13:15 PM10/11/03
to
If it was a .csv file, it will open without the wizard. To separate the
elements, select the first column, and choose Data>Text to Columns. Then
follow the steps that Dave described.
elements, select the first column, and choose Data>Text to Columns. Then
follow the steps that Dave described.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
babara
Oct 11, 2003, 4:27:32 PM10/11/03
to
sometimes when you open a txt file the wizard does not
appear to parse it. if that is the case try this:
1.select the entire column
2. goto tools>text to column
3. the wizard will now appear and you prob want to choose
deliminate. you will have to choose tab, space etc for
delimination. this depends on the data. If you don't like
the results undo and do it again.
>.
>
0 new messages