CSV String to consecutive cells

[RzB]

I have a string like this...

"05-Nov-03,0,2,3,2,20,30"

and I want to put these values into consecutive cells.
Is there some way I can do this in one go or have I got
dig each value out of the string etc...

Thanks,
Roy

 

[Ron de Bruin]

Try Data Text to columns in the menubar

 

[RzB]

Ron,
Oooo - That worked just fine...
Many thanks for the pointer.
Roy