Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i seprate multi data cell into 2 or more cells
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a cell so I can have the data it contains in seve. | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Repeat Cell Data | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |