You could try datatext to columns and choose space a delimiter, that will
parse all
then you just merge the first 2 columns like if you got 12 in C, 9 in D, 1 i
E and 2 in F, then use one extra column and =C15&" "&D15 then copy down,
that's what I would do If you want a formula, in C15 put

=LEFT(B15,FIND("^^",SUBSTITUTE(B15," ","^^",2)))

in D15 put

=LEFT(SUBSTITUTE(B15,C15,""),FIND(" ",SUBSTITUTE(B15,C15,""))-1)

and in E15 put

=MID(B15,FIND("^^",SUBSTITUTE(B15," ","^^",3)),255)

Regards,

Peo Sjoblom

"Jay" wrote:

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