Auto Delimit on Excel 2010

[biskwit]

[h=2]

Re: Need help, multiple criteria with approximate matching[/h]

Date	Time
09/24 - 16:45:33
09/24 - 17:56:40
09/24 - 20:51:39
24-Sep	16:45:33
24-Sep	17:56:40
24-Sep	20:51:39

<tbody>
</tbody>

Is there a way to do auto delimit, like when i paste this data here, it should automatically delimit and would give me the date on column 1 and time on column 2.

Thank you so much!​

 

[adam087]

Hi Biskwit

Do you need it to be in the same column as you paste, or could you paste in to Column A and get the dates and times out of Col B & C?

Excel 2010

	A	B	C
1	Paste	Date	Time
2	28-Jul-14 03:06	28-Jul-14	3.06 AM
3	16-Dec-14 13:16	16-Dec-14	1.16 PM
4	17-Jul-14 16:07	17-Jul-14	4.07 PM
5	19-Aug-14 10:38	19-Aug-14	10.38 AM
6	07-Jul-14 01:30	07-Jul-14	1.30 AM
7	03-Jul-14 23:20	03-Jul-14	11.20 PM
8	25-Jul-14 10:38	25-Jul-14	10.38 AM
9	15-Aug-14 10:38	15-Aug-14	10.38 AM
10	09-Oct-14 10:38	09-Oct-14	10.38 AM
11	13-Sep-14 21:51	13-Sep-14	9.51 PM
12	08-Jul-14 14:31	08-Jul-14	2.31 PM

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B2 =INT(A2) C2 =MOD(A2, INT(A2)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Hope that helps

/AJ

 

[biskwit]

sorry i missed one important detail. It because when i export the data. It gives me the date and time in **** format.

"09/24 - 03:06"

which is not recognized as a date, that's why i use delimit feature to remove it make it look like dates and times.