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

[Guest]

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

 

[Max]

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

 

[gls858]

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