you can use "text to columns" option available in excel.


On Jun 13, 12:49*pm, Juswant Rai <Juswant
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