=DATEVALUE(LEFT(A1,FIND(" ",A1)))+TIMEVALUE(LEFT(RIGHT(A1,LEN(A1)-FIND(" ",A1)),2)&":"&RIGHT(RIGHT(A1,LEN(A1)-FIND(" ",A1)),2))

Format Custom as mm/dd/yy hhmm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"samuel" wrote in message ...
|I have a text column 02/21/08 2315
|
| I want to convert this to an actual date/time column keeping in military
| format.