Splitting cells
 

Is there a way in Excel to split a cell into multiple cells?

Splitting cells
 

You can "split" contents using datatext to columns


--


Regards,


Peo Sjoblom



"Splitting one cell into multiple cells" <Splitting one cell into multiple
wrote in message
...
Is there a way in Excel to split a cell into multiple cells?

Splitting cells
 

Select the column of data and then click DATA in the menu, select TEXT TO
COLUMNS.

You'll want to make sure that there are enough blank columns to the right of
the source data to accommodate the parsed data.
--
Kevin Backmann


"Splitting one cell into multiple cells" wrote:

Is there a way in Excel to split a cell into multiple cells?

Splitting cells
 

On Wed, 19 Sep 2007 08:04:01 -0700, Splitting one cell into multiple cells
<Splitting one cell into multiple wrote:

Is there a way in Excel to split a cell into multiple cells?

Yes there is.

The applicable method depends on details you have not chosen to provide,
however.
--ron