How to remove space or "nextline" in front of date?

I am working on an excel with more than 60,000 rows of data. There is a column with date but sometimes there is space or "nextline" in front of the date. How do I remove these? I cannot work on the data until I can clean this up, thanks!

use Trim option

Originally Posted by VICTOR55

use Trim option

I tried and this doesn't work because it transfer the date to numbers and cannot convert back to date.

Use Data >>> Text to Columns
In step-3 Choose Date option.

Hi J2ee,

Mark this post SOLVED if get your answer!