| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A function to read a number and split it in separate cells
I have numbers like,
abs1: xxxx:qw124a: 124 abs:xyz:123456788:12 How can I use any function that reads the ":" and then split values between ":" into separate cells. The number of values between ":" might not be constant, as you can see from the examples above. I would appreciate any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to split number and text string to separate cells? | Excel Discussion (Misc queries) | |||
| Split a number from one cell to separate cells for each | Excel Discussion (Misc queries) | |||
| Need to split a 17 digit number into 17 cells by paste function. | Excel Discussion (Misc queries) | |||
| split text into separate cells | Excel Worksheet Functions | |||
| Split date in cell into 2 separate cells | Excel Discussion (Misc queries) | |||
Threaded Mode
