| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
A function to read a number and split it in separate cells
Test this first on a sample, make sure these values are in a single column
and there are empty columns to the right Datatext to columns, delimited, click next and select : as delimiter and click finish. Make a backup before you do this -- Regards, Peo Sjoblom "zen" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
A function to read a number and split it in separate cells
Data|Text to Columns, choose : for your delimiter..... (check Other, and type
: in the box). -- ** John C ** "zen" wrote: 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. |
| Reply |
| 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) | |||
Linear Mode
