Divide DateTime to Date and Time

Giganews Newsgroups
Subject: Divide DateTime to Date and Time
Posted by:  Mark (anonymousu…@gmail.com)
Date: Wed, 16 Jul 2008

Hello,

I have a text file with several columns one of which represents dates
in the following format:

dd mmm, yyyy hh:mm:ss AMPM

For example:

03 July, 2008 2:13:16 PM
11 August, 1976 11:03:50 AM

I need to get the date and time portions in different columns. I have
tried datevalue, timevalue, text, etc. but still cannot divide the two
portions. I would like to do this without any macro or VB/VBA code.

Is it possible? I am using Excel 2007

Thanks

Replies