title: VBA - Date and Time, Clean and Format
body: <p>I have imported data from Outlook into the Sheet, in <code>Column E</code> which has the part of the Body of Email i.e., the Order Date and Time. The column is in the format - <code>"yyyy-mm-dd h-mm"</code>. But, the cell contains extra line. I have tried to use - <code>CLEAN()</code>, <code>SUBSTITUTE()</code>, <code>REPLACE()</code> nothing worked.
  When I manually edit the cell, by pressing backspace twice, the blanks are removed and the formats are applied automatically.</p>
  
  <p>How do I do this for 30,000 rows?</p>