A function to read a number and split it in separate cells

[zen]

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.

 

[Peo Sjoblom]

Test this first on a sample, make sure these values are in a single column
and there are empty columns to the right

Data>text to columns, delimited, click next and select : as delimiter and
click finish.

Make a backup before you do this

--


Regards,


Peo Sjoblom

 

[John C]

Data|Text to Columns, choose : for your delimiter..... (check Other, and type
: in the box).