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?