Tip #129 – Excel

Excel: Cleaning Up Badly-Imported Dates


When importing data from another source, sometimes you get a mangled mess that prevents you from using Excel’s great functions to analyze that data.


DATES are a good example.


If imported data makes your dates look something like 20150409 you won’t be able to perform date calculations on that data.


A really quick way to clean up dates? TEXT-TO-COLUMNS.


Full tip: Excel tip