CSV String to consecutive cells
 

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

CSV String to consecutive cells
 

Try Data Text to columns in the menubar

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"RzB" wrote in message ...
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

CSV String to consecutive cells
 

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