I am trying to do something rather unusual and I wondered if it is possible in Excel. I want to take a group of cells within one column and merge them together, and then split them apart again into a different number of cells than I started with.
For example:
1.) Merge four cells within one colum into one big cell (<----I already know how to do this.)
2.) Split this new merged cell apart into FIVE cells. This would mean that the rows would no longer go straight across, because adjacent colums would not be divided the same way.
It may not be possible, but I thought I'd inquire.
Thanks in advance for your help!
crcclar
For example:
1.) Merge four cells within one colum into one big cell (<----I already know how to do this.)
2.) Split this new merged cell apart into FIVE cells. This would mean that the rows would no longer go straight across, because adjacent colums would not be divided the same way.
It may not be possible, but I thought I'd inquire.
Thanks in advance for your help!
crcclar