Text to date
 

Try this

=--MID(SUBSTITUTE(A1,".",""),5,99)
Format cell as m/dd/yy hh:mm

"Arun2902" wrote:

Hi,

Hope someone can help me with this. I am trying to convert "Wed. Sep. 20,
2006 14:16" into a format recognized by excel (9/30/06 14:16). Have tried to
extract and collate the data using
"=CONCATENATE(VALUE(RIGHT(LEFT(B3,12),2))," ",RIGHT(LEFT(B3,8),3),"
",RIGHT(LEFT(B3,18),4)," ",RIGHT(B3,5))", but all my efforts are in vain when
I try to convert it to a date and time format recognized by excel. The lenght
of the text that I'm trying to convert is exactly 24 characters.

Hope someone can help me with this.

Thanks

Arun