Splitting Cells

  • Thread starter Thread starter DonDavis
  • Start date Start date
D

DonDavis

Does Excel 2002 allow splitting a cell? I have been asked that
question, and I cannot find the answer on this site. Maybe one of you
can help.
Thanks,
Don
 
Hello DonDavis,

Depends on what you mean by 'splitting a cell'. This can be taken a few
ways. There are some functions which you can use that will look at a cell
and show specific (as directed by character number/locations) parts of a
cell and show them. These are LEFT, MID and RIGHT functions. A way to
actually take what's in a cell and split it into various columns, there is
also the Text to Columns feature, found under the Data menu.

Not sure what else to tell you as I'm unsure what else you need.
 
I think Don wants to split the cell so that it becomes two table cells
like in MS Word. In Excel you cannot split cells within cells or create
another table within a cell. To get the same effect you must insert
a whole column then except for your two adjacent cell, merge all the
other cells in the column (row by row).
Merge and Unmerge Cells
http://www.mvps.org/dmcritchie/excel/merge.htm

Merged cells interfere with sorting and adjusting cell width and height
so they are much more useful in simulating forms than in working
as a spreadsheet where you typically insert rows and columns.
 
Back
Top