Is there any way to split contents of a cell into more cells.
 

in a cell i am having date like 123, 435, 546, 546. I want now the 123 in one
cell, 435 in another cell, 546 in another cell and so on. It there any way
to split the contents of a cell into more cells.

Is there any way to split contents of a cell into more cells.
 

Hi,

Have a look at Data|Text to columns and use comma as a delimiter.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"saravanan" wrote:

in a cell i am having date like 123, 435, 546, 546. I want now the 123 in one
cell, 435 in another cell, 546 in another cell and so on. It there any way
to split the contents of a cell into more cells.

Is there any way to split contents of a cell into more cells.
 

Check out DataText to columns or if you are looking for formulas try the
below in cell B1 and copy to the right with data in cell A1

=TRIM(MID(SUBSTITUTE("," & $A$1& REPT(",",6),",",
REPT(CHAR(32),255)),COLUMNS($B$1:B$1)*255,255))

--
Jacob (MVP - Excel)


"saravanan" wrote:

in a cell i am having date like 123, 435, 546, 546. I want now the 123 in one
cell, 435 in another cell, 546 in another cell and so on. It there any way
to split the contents of a cell into more cells.