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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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

Select B1:C1, fill down
 
vinlouis said:
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
Click to expand...
Select the entire column go to Data > text to columns and
follow the prompts to split the data as needed.

gls858
 
Back
Top