Trim text and split across three columns

[Juswant Rai]

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

 

[muddan madhu]

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

 

[Sri]

help me in trimming the leading spaces of text in columns. TRIM is not
deleting the spaces in the begining of the text. any help?

 

[David Biddulph]

If TRIM doesn't remove your leading spaces, then the characters are
presumably not spaces.
Does =CODE(LEFT(A1)) return 32? If not, the character isn't a space. It
may be a non-breaking space (160 instead of 32). You may need to use a
SUBSTITUTE function.