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.
--
David Biddulph

Sri wrote:
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?

"muddan madhu" wrote:

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