| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split text into multiple columns using a common delimiter
My data in col A is as follows:
1*15 101268*6 101352*16 101513*11 10406*2 10406*37 10411*13 10411*7 I want to add two columns with the data preceding the * going into Col B and the data following the * going into Col C. I can't use RIGHT or LEFT because the data is not the same length. If someone knows a way to do this, I'd certainly appreciate knowing how. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| "Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I create multiple columns from a one-column list in Excel? | Excel Worksheet Functions | |||
| Combining text from multiple columns into 1 | Excel Discussion (Misc queries) | |||
| splitting text to multiple columns | Excel Discussion (Misc queries) | |||
Threaded Mode
