The Clean and convert a column of dates in Excel Numbers Wizard!
Paste a column of dates from Excel, a mixed column which contains inconsistent strings like:
2010-10-05
june 10, 2010
Sept 17th 2011
June 11/2011
oct 8 2011
and many other combinations (or leading and trailing spaces) and we will try to return a clean list that can be easily used in Excel. This is useful if you have a table of manually entered data with a date column that is messy. Paste your results into a new column in Excel so that you can manually review the results - this tool is awesome, but not omniscient. Any lines that can not be reasonably interpreted will be returned as-is.