Convert Text to Date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Assume this is in one column and you only need the date?
If you want to keep the time make sure there is an empty column to the
right,
select the column, do data>text to columns, select fixed width and click
next, make sure one line is right after the year and double click the other
lines and click next, if you want to remove what's to the right of the date
select the column to the right and select don not import (skip) then click
finish
If you want to keep what's to the right just click finish in step 2 after
setting the lines


--


Regards,


Peo Sjoblom
 
Back
Top