J
jayfin
Can a column of cells be split into two equal parts with a line in the
middle? If so, how? I am using Excel 2000.
middle? If so, how? I am using Excel 2000.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gordon
jayfin said:Can a column of cells be split into two equal parts with a line in the
middle? If so, how? I am using Excel 2000.
Certainly later version have a "Text to Columns" function - not sure about
2000......SUCH a long time since I used it!!!!!
G
Gord Dibben
A cell itself cannot be split into parts.
The contents of a cell can be split into multiple cells.
Gord Dibben MS Excel MVP
The contents of a cell can be split into multiple cells.
Gord Dibben MS Excel MVP
J
JMB
XL2000 has text to columns feature (Data/TextToColumns)
G
Gordon
JMB said:XL2000 has text to columns feature (Data/TextToColumns)
Thanks - I thought it might have but it's SO long since I used 2000 I wasn't
sure!
J
jayfin
It jayfin again. Thanks for the input. I decided that for my needs which
did not call for any manipulation of data, sorting etc., it would be easiest
to just take two columns and use the "merge and center" button over two
columns and label it with a centered title on one line of a cell and then on
the second line of the cell using the wrap text feature put a label above
each column. Had to do this with 25 columns but it did work.
did not call for any manipulation of data, sorting etc., it would be easiest
to just take two columns and use the "merge and center" button over two
columns and label it with a centered title on one line of a cell and then on
the second line of the cell using the wrap text feature put a label above
each column. Had to do this with 25 columns but it did work.
J
JMB
We just upgraded to XL03 from XL00 at work <g>.