Perceptus Solutions Inc. » blog | Bingo Card Generator | Papaya Polls - Simple Surveys | Naque for Unique Names | Ivy DSL - internet for retailers | other

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.

Enter the data: