(Solved) – VBA – Date and Time, Clean and Format


I have imported data from Outlook into the Sheet, in Column E which has the part of the Body of Email i.e., the Order Date and Time. The column is in the format – “yyyy-mm-dd h-mm”. But, the cell contains extra line. I have tried to use – CLEAN(), SUBSTITUTE(), REPPLACE() nothing worked.
When I manually edit the cell, by pressing backspace twice, the blanks are removed and the formats are applied automatically.

How do I apply it for 30000 rows?

Leave a Reply

Your email address will not be published. Required fields are marked *