One way.Copy the formulas and drag down as required..

In B1
=TRIM(LEFT(TRIM(A1),FIND(" ",TRIM(A1))))

In C1
=LEFT(TRIM(SUBSTITUTE(A1,B1,"")),FIND(" ",TRIM(SUBSTITUTE(A1,B1,))))

In D1
=TRIM(SUBSTITUTE(SUBSTITUTE(A1,B1,),C1,))

If this post helps click Yes
---------------
Jacob Skaria


"Juswant Rai" wrote:

I am trying to slit the following text info across three columns

xxxxx yyyyyy zzzzzzzzzzzzzzzz

Is there a function that will allow me to do this without having to type all
the info into separate columns

Can I just copy it all into three columns and trim out the all but the xxxxx

and then in the next column yyyyyy


Juswant