title: Convert long date strings in Excel into a sortable date/time format
body: <p>I have an Excel spreadsheet full of text dates formatted like this:</p>
  
  <p><code>Thursday, 23 April 2015, 9:19 AM</code></p>
  
  <p>Because they're text, Excel can't sort them chronologically. How do I convert them into a format Excel can work with? </p>
  
  <p>Also, for my future reference, is there a name for this day/date/time format?</p>