| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying text to split into columns | Excel Worksheet Functions | |||
| Text to Columns or TRIM? | Excel Discussion (Misc queries) | |||
| Text to columns, split at first space only | New Users to Excel | |||
| split text , insert to columns | Excel Discussion (Misc queries) | |||
| How do I split 16 char text 'XX XXX= +. X' into 16 columns | Excel Discussion (Misc queries) | |||
Threaded Mode
