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.