Actually, I used this in D15:

=MID(B16,6,1+(LEN(B16)=9)*1)

Jason
-----Original Message-----
C15:

=LEFT(B15,4)

D15:

=MID(B15,6,1+LEN(B15)=9)

E15:

=RIGHT(B15)

HTH
Jason
Atlanta, GA
-----Original Message-----
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
.

.