Hi
try starting with 'Data - Text to columns' for this

--
Regards
Frank Kabel
Frankfurt, Germany
"Jay" schrieb im Newsbeitrag
...
I have this field containing data like such in column (B15:B21):

12 9 1 2
12 9 1 1
12 9 50 4
12 9 50 3
12 9 50 2
12 9 50 1
12 9 49 4

What I need to do is pull out the various components into three other
column
fields (C),(D),(E).

I need to have the 12 9 to be in column (C) and be the month 12 day 9 ,
then
in column (D) have the value 1, 50 and 49 and in column (E) have the value
2,
1, 4,3,2,1,4. Basically a parsing function using the spaces between the
values to seperate them into respective cells. Is this possible, I know it
is
in Access but I'm at a loss for Excel.

Looking forward to your input....

Thanks