View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Juswant Rai Juswant Rai is offline
external usenet poster
 
Posts: 1
Default Trim text and split across three columns

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