Seperate date and time

[RD]

Using Excel 2007 is their a way to seperate this format in one cell:
6/24/2009 12:01:32 PM to two cells with the date in one and the time beside
it in another cell: (cell A) 6/24/2009; (cell B) 12:01:32 PM

 

[Teethless mama]

=INT(A1)
format cell as Date

=MOD(A1,1)
format cell as Time

 

[Shane Devenshire]

Hi,

1. Highlight all the date/time enteries and choose Data, Text to Columns,
Fixed Width, click Next. In the Data preview area leave one line (arrow)
directly to the right of the longest dates, and remove any other lines.
Click Next, choose a Destination cell and click Finish.

 

[RD]

Yes. Thanks.

Hi,

1. Highlight all the date/time enteries and choose Data, Text to Columns,
Fixed Width, click Next. In the Data preview area leave one line (arrow)
directly to the right of the longest dates, and remove any other lines.
Click Next, choose a Destination cell and click Finish.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

 

[RD]

This works but Shane devonshire's below did the best for my situation.
Thanks.