How to Split a Single Cell in Microsoft Excel 2007

How to Split a Single Cell in Microsoft Excel 2007
I need help to split single cell into multiple cell. I tried to use a script for the same which ended to a error.
Reply With Quote
#2
Old 11-01-2012
DanielaA DanielaA is offline
Member

Join Date: Jun 2011
Posts: 754
Re: How to Split a Single Cell in Microsoft Excel 2007
Use the white space (here) to describe your problem in more detail. Do you want to extract data from a single cell into two or more other cells. Instead of trying to split your cell G6 in two overlapping cells, you must try this out. This is just a example. Assum that there is data in reference cells.

* Insert a new row 7
* Merge A6 and A7, B6 and B7 ... F6 and F7, H6 and H7 ...
* Distribute your data between G6 and G7 (unfused)
* Select lines 6 and 7 and do Format / Alignment / Vertical / Centered

Reply With Quote
#3
Old 11-01-2012
GaganjyotTechie GaganjyotTechie is offline
Member

Join Date: May 2011
Posts: 433
Re: How to Split a Single Cell in Microsoft Excel 2007
You can not split a cell in excel, it's not like in Word.The only thing you can do is add a column in the cell and distribute the data.

If you like this post then consider sharing it with others.