Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

How do split a cell in half in excel

Posted by mary on December 30, 2001 2:51 AM

How do split a cell in half in excel

Mary


Re: How do split a cell in half in excel

Posted by EliW on December 30, 2001 4:30 AM

What do you mean by "split a cell in half"?
Please give an example
Eli


Re: How do split a cell in half in excel

Posted by Jacob on December 30, 2001 4:41 AM
If you know where you want to split it take a look at these formulas. Find and mid.

Jacob Mary


Re: How do split a cell in half in excel

Posted by Jack in UK on December 30, 2001 10:34 AM
Mary

Hi Mary
Stay on this feed,
OK Split cells you cant, so i guess so other reason

you can only enter text or numbers in a cell all be in complex BUT....

="MrExcel is the Best"&CHAR(10)&"SAYS us all:
"&TEXT(NOW(),"dddd dd mmmm yyyy")

Will look silly unless you wrap text, copy and paste the formula and wrap txt is this what you mean?

Also ALT+Enter will devide wrapped text data the same way, but will fall abart if copy/paste and reformatted.

If im wrong need more info, in what in the cells and what exact answer you require.
HTH
Jack


Re: How do split a cell in half in excel

Posted by Mary on December 31, 2001 2:41 AM
Mary

What I mean is I am trying to create a form. You know how you can split a table cell in word. I want to do the same in excel. I want to drag cells to different lengths. But I can't do that with out dragging the whole column.

Thanks Mary


Re: How do split a cell in half in excel

Posted by Bariloche on December 31, 2001 8:17 AM
Mary,

In Excel you can either change the height and/or width of the cell or you can merge the cell with adjacent ones to create a larger cell.

Given these "restrictions" it sounds to me like you would want to use two cells (say, A1 and A2) and then merge the cells in B1 to lets say G2 so that you have the appearance of a "cell" split in half. You then can dink around with the height of the cells to further refine the appearance.

I know this isn't what you may be used to using Word's forms functionality, but its the way it is. Each application has its strong suites, forms creation isn't one of Excel's, but it can be done. It just takes some planning and some dinking around. :-))


take care


Oops, sorta

Posted by Bariloche on December 31, 2001 8:23 AM
Mary,

Just noticed that your frustration is with cell (column) widths. My previous post still applies except you will have to use cells A1 and B1 and merge the cells below (i.e., cells A2 to B??).

If you're modifying an existing lay out, try inserting a new column and then using the two cells you need (your existing cell and the new one adjacent to it) and merge the other cells below it.

enjoy

Mary, In Excel you can either change the height and/or width of the cell or you can merge the cell with adjacent ones to create a larger cell. Given these "restrictions" it sounds to me like you would want to use two cells (say, A1 and A2) and then merge the cells in B1 to lets say G2 so that you have the appearance of a "cell" split in half. You then can dink around with the height of the cells to further refine the appearance. I know this isn't what you may be used to using Word's forms functionality, but its the way it is. Each application has its strong suites, forms creation isn't one of Excel's, but it can be done. It just takes some planning and some dinking around. :-))



This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.