Printable View
Hello All
I am making a report in excel and am manipulating the first few rows for titles and details of the report.
I was wondering how would i be able to split 1 cell into 2 or 3
Reason I have a row of 7 columns and i want to create 3 equal coloumns so i merge the row into one cell
VB Code:
then i want to split this new cell into 3 but i do not know the syntax. :confused:
Thanks.
Split cells in Excel? I don't think it's possible, even in Excel itself. But, if you know the way to do it in Excel (manually), then save the Macro and take a look at the VB editor to get the code generated.
jcis
Thats what i was afraid of. I'm not sure how to do it maually in excel and i was hoping that wasn't because it couldn't be done.
Unless anyone else has any ideas i guess i'll have to re evalute my layout.
Cheers jcis
What you coul do is insert a column next to the cell's column.
Then join the cells above and below the cell with the cells in the new column.
Top Idea Jeroen79
I have already changed the layout to not need to do this, but in the future if i have to have a report as such, i'll give it a try.