how to split data in a range to many ranges

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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.
 
Data|Text to columns
Delimited by commas

Looks like it should work.
 
You must log in or register to reply here.

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

excel external data range "failed to refresh" 0
excel external data range failed to refresh - second try 1
Frequency of items in a huge range 3
Countif function with two ranges, possible? 2
Combine words from columns 17
For Eachcell in Range tranpose comma seperated values to a list in D 4
VBA set thick borders around non empty cells in range 0
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2

Back
Top