title: Split DateTime string, ArrayFormula, Google Spreadsheet
body: <p>I have a 'Date' 'at' 'Time' string in A1, for example:</p>
  
  <blockquote>
    <p>A1: December 27, 2013 at 08:24AM</p>
  </blockquote>
  
  <p>I would like to have Date and Time in B1 and C1, for example:</p>
  
  <blockquote>
    <p>B1: 12/27/2013
    C1: 8:24:00</p>
  </blockquote>
  
  <p>How to split the A1 into B1 and C1? 
  And what if I have a new row like</p>
  
  <blockquote>
    <p>A2: January 02, 2014 at 08:28AM</p>
  </blockquote>
  
  <p>then </p>
  
  <blockquote>
    <p>B2: 01/02/2014
    C2: 08:28:00</p>
  </blockquote>
  
  <p>can be generated automatically?</p>
  
  <p>It seems I can achieve this via "ArrayFormula" and "REGEXEXTRACT", but after lots of search, I still can not find the formula to apply to my spreadsheet.</p>