how do i seprate multi data cell into 2 or more cells

eg :
<Single Cell
01-Dec-04 01:46:42 AM
01-Dec-04 05:07:21 PM
10-Feb-05 06:29:48 PM
01-Dec-04 06:05:18 PM
01-Dec-04 06:24:37 PM
01-Dec-04 07:05:51 PM

into
<Cell 1 <Cell 2
01-Dec-04 01:46:42 AM
01-Dec-04 05:07:21 PM
10-Feb-05 06:29:48 PM
01-Dec-04 06:05:18 PM
01-Dec-04 06:24:37 PM
01-Dec-04 07:05:51 PM

please help,

Thank,
vinLouis

One try ..

Assuming data is in col A, A1 down,

<Single Cell
01-Dec-04 01:46:42 AM
01-Dec-04 05:07:21 PM
10-Feb-05 06:29:48 PM

Put in B1: =TEXT($A1,"dd-mmm-yy")
Put in C1: =TEXT($A1,"hh:mm:ss AM/PM")

Select B1:C1, fill down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"vinlouis" wrote in message
...
how do i seprate multi data cell into 2 or more cells

eg :
<Single Cell
01-Dec-04 01:46:42 AM
01-Dec-04 05:07:21 PM
10-Feb-05 06:29:48 PM
01-Dec-04 06:05:18 PM
01-Dec-04 06:24:37 PM
01-Dec-04 07:05:51 PM

into
<Cell 1 <Cell 2
01-Dec-04 01:46:42 AM
01-Dec-04 05:07:21 PM
10-Feb-05 06:29:48 PM
01-Dec-04 06:05:18 PM
01-Dec-04 06:24:37 PM
01-Dec-04 07:05:51 PM

please help,

Thank,
vinLouis

vinlouis wrote:
how do i seprate multi data cell into 2 or more cells

eg :
<Single Cell
01-Dec-04 01:46:42 AM
01-Dec-04 05:07:21 PM
10-Feb-05 06:29:48 PM
01-Dec-04 06:05:18 PM
01-Dec-04 06:24:37 PM
01-Dec-04 07:05:51 PM

into
<Cell 1 <Cell 2
01-Dec-04 01:46:42 AM
01-Dec-04 05:07:21 PM
10-Feb-05 06:29:48 PM
01-Dec-04 06:05:18 PM
01-Dec-04 06:24:37 PM
01-Dec-04 07:05:51 PM

please help,

Thank,
vinLouis
Select the entire column go to Data text to columns and
follow the prompts to split the data as needed.

gls858