CSV String to consecutive cells

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Word macro that can call cells out of Excel for a find and replace 0
CSV files and having numbers and strings in there... 9
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
location of highest consecutive values 0
Finding location (or start cell) of highest consecutive values 3
VBA - exporting serial letters to single documents 0
Updatig the Next Consecutive Empty Cell in a Range 3

Top