Splitting a cell

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.
 
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.
Click to expand...


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split cells next to 1 cell 1
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Split form 0
How to count the numbers in a Word document? 0
How to set tabs in work document 0
Two columns followed by single page-width column on same page 0
Split single cell into multiple cells 2
Footnote references on one page, footnote text on the next 5

Top