Assuming that the date is A1:

=DATEVALUE(LEFT(A1,11))

The LEFT function extracts the first 11 characters on the left side of the
entry and the DATEVALUE function converts the text to a valid date serial
number. You'll have to format the cell for the date format of your choice
--
Kevin Backmann


"Fellow Wanderer" wrote:

I have a file with text as follows:
31-Jul-2007 05:07:48 PM PDT

Is there some way for excel to convert this to a standard date?