CODEWITHSUNDEEP
excel
Teemo
Teemo

Reputation: 1

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

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!

Upvotes: 0

Views: 5747

Answers (2)

sam092
sam092

Reputation: 1335

Can you add a new column with this formula

=IF(ISTEXT(A1),TRIM(A1),A1)

Then manually change the formatting to date.

Upvotes: 1

matzone
matzone

Reputation: 5719

It contain CR so ...

=SUBSTITUTE(A1,chr(10),"")

Upvotes: 0

Related Questions