MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Parsing Text To Columns


Posted by Emy on February 12, 2002 8:21 PM

I have a text file with the following data:

20 60 40 Apple
10 12 31 Orange
62 22 11 Banana
11 22 33 Orange
12 33 23 Apple
11 22 33 Banana

How can Excel parse this data so that each fruit has its own column, i.e.:

R1C1: 20 60 40 Apple
R2C1:12 33 23 Apple
R1C2: 10 12 31 Orange
R2C2: 11 22 33 Orange, etc.

I've tried inserting tabs at the end of each line and using that as a delimiter, but it doesn't separate each fruit in its own column. Thanks very much in advance.


Posted by Juan Pablo G. on February 12, 2002 9:17 PM

Have you tried using, Data, Text to Columns ? [NT]

Posted by Emy on February 14, 2002 8:05 PM

Re: Have you tried using, Data, Text to Columns ? [NT] - Yes, and it doesn't work

I have been using text to columns, and it hasn't been doing what I need to do with the data.

My end objective is to have 3 columns - "Apple", "Orange" and "Banana" , and
each column will have the numbers belonging to each fruit, for example,
under the column labeled "Apple", I would have:

In row 1 under "Apple": 20 60 40
In row 2 under "Apple": 12 33 23

In the column labeled "Orange", I would have:
In row 1 under "Orange": 10 12 31
In row 2 under "Orange": 11 22 33