title: How to split datestamp in Google Sheets
body: <p>I have a datestamp in this format on A2:</p>
  
  <pre><code>18.11.2015 15:37:13
  </code></pre>
  
  <p>How can I split this into date and time so that I have date in A3 and time in A4?</p>
  
  <p>I want to do this because datestamp does not sort properly as a number.</p>
  
  <p>I found several answers to this question with various answers but none of them worked for me.</p>