Converting Date and Time in Text String to Datetime format

[beginner321]

I have a spreadsheet with text strings representing dates and times. An example would be "Tuesday, January 1, 2012 9:02:01 PM". I need to convert this to the Datetime format. I'm wondering if someone can share ideas about how to do this.

 

[FDibbins]

Try this...
=DATEVALUE(MID(F9,FIND(",",F9)+2,99))+TIMEVALUE(MID(F9,FIND(":",F9)-2,99))
then Format Custom dddd, mmmm, d, yyyy h:mm:ss AM/PM

 

[beginner321]

FDibbins:

Your proposed solution appears to work perfectly. Thank you very much for your assistance on this.

Beginner321

 

[FDibbins]

Happy to help