|
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 |
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 |
| All times are GMT +1. The time now is 12:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com