Splitting Data

[Tracemark]

I have cells which contain date and time (29/02/2012 11:12:40)

I need the date to remain and the time to be removed and placed in an adjacent cell

Anyone know of a quick method to do this?

 

[VoG]

Try like this

Excel Workbook
	A	B	C
1	29/02/2012 11:12	29/02/2012	11:12:40
Sheet3

 

[dsouzahit]

You do Text to column with space. E.g. given below

Split names by using the Convert Text to Columns Wizard - Excel

 

[Tracemark]

Try like this

Sheet3

*	A	B	C

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:134px;"><col style="width:100px;"><col style="width:92px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: right"]29/02/2012 11:12[/TD]
[TD="align: right"]29/02/2012[/TD]
[TD="align: right"]11:12:40[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B1 =INT(A1) C1 =MOD(A1,1) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Thanks.

The date column works fine but the time appears as 01/01/1900