How do split a cell in half in excel

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

If you know where you want to split it take a look at these formulas. Find and mid.

Jacob Mary

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

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

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

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. :-))