I am unable to clean data. In the date column there are different formats. Like some of them has space-between and they are not registered to the date. I used the filter and here it is in the image.
Excel Filter
I did try to do change the formatting from custom to date, but it didn’t change.
Then I tried to do text to column and separate using delimiters and get the date but it also didn’t work. I just want all the other dates to be in the 2016 checkbox.
New contributor
Akash Kumar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.