Convert Text to date

[cimajc17]

Is there any way I can convert this text

May 31 2015 6:17PM Into a date and time. Thank you in advanced

<tbody>
</tbody>

 

[Jonmo1]

Welcome to the board.

If that's a consistent representation of the string, try

=SUBSTITUTE(REPLACE(A1,LEN(A1)-1,0," ")," ",", ",2)+0

 

[cimajc17]

Thanks so much for the quick responce

 

[Jonmo1]

You're welcome.

 

[cimajc17]

Once I get the serial number I used
=TEXT(B1,"m/d/yy ")
to extract the date.
Is there a formula to extract time and put it in to C1?

 

[Jonmo1]

I would use these to seperate the date and times..

B1 has the formula before

DATE: =INT(B1) format cell with formula as Date
TIME: =MOD(B1,1) format cell with formula as Time

 

[gaz_chops]

Try

=MOD(B1,1)

Format result as time.

 

[cimajc17]

Thanks works great!!