Trim text and split across three columns

J

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
 
S

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separate columns (three letter code) 7
Excel Concatenate with line breaks but ignore blank cells 3
Split cells across multiple columns 1
Split column contents (de-concantenate) 7
Turn off text to columns 10
Compare worksheets 4
my zero keeps dropping even though formatted as text 3
Text to Columns or TRIM? 2

Top