Uploaded March 2014 | Updated September 2026, 1 hour ago
Watch this video to see an example of how to clean up dirty data. If you can find a pattern then you just need to know string manipulation functions (or maybe text to columns) to clean it up. Download the Excel file here: http://1drv.ms/1bYwrTa
Watch this video to see an example of how to clean up dirty data. If you can find a pattern then you just need to know string manipulation functions (or maybe text to columns) to clean it up. Download the Excel file here: http://1drv.ms/1bYwrTa










