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" wrote:

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