Split Cells

[Confused]

Is it possible to split a single cell to display more than one value?

 

[Myrna Larson]

You can put two numbers in one cell using CONCATENATE or the & operator. The
result is text, and you won't be able to use these numbers in other formulas
unless those formulas use functions to split them apart again.

 

[Gord Dibben]

No.

What do you want to do?

A description of your needs may result in a solution.

Gord Dibben Excel MVP

 

[David McRitchie]

MS Word can split a cell into two cells, but not Excel.

You might see if this would look presentable, the vertical line
will not touch the borders abc | def
you can reduce the row height to make it touch the borders,
which may or may not be noticeable.

The other solution would be to insert another column
then merge the cells in the two columns row by row
except for that two cells that are to be distinguished.
You can use the Merge Across toolbar button.
http://www.mvps.org/dmcritchie/excel/merge.htm#builtin

 

[David McRitchie]

Row by row may just be just as ambiguous in implementation
as what I was trying to avoid ambiguity in the description.

So the implementation is to select the two column (old + empty
inserted column) and use the merge across, then select the
single duplet and unmerge the two cells. Then fill those two
cells as wanted. The inserted column would be to right, of course.