Trim text and split across three columns
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
|