how to split data in a range to many ranges

Paul · Feb 20, 2005

I have data in a range, like 1,2,3,4,5.
I want to split each of them to five different ranges.
How to do it. thanks.

Dave Peterson · Feb 20, 2005

Data|Text to columns
Delimited by commas

Looks like it should work.

Paul · Feb 20, 2005

Thank you, Dave. I made it.

Dave Peterson said:
Data|Text to columns
Delimited by commas

Looks like it should work.