Seperate date and time

  • Thread starter Thread starter RD
  • Start date Start date
R

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
 
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.
 
Yes. Thanks.

Shane Devenshire said:
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
Click to expand...
 
Back
Top