My Data Is Dirty! Basic Spreadsheet Cleaning Functions by Paul Bradshaw.
A sample from Paul Bradshaw’s new book, Finding Stories in Spreadsheets.
Data is always dirty but you don’t always need a hazmat suit and supporting army of technicians.
Paul demonstrates Excel functions (sniff, other spreadsheet programs have the same functions), TRIM, SUBSTITUTE, CHAR, as easy ways to clean data.
Certainly makes me interested in what other techniques are lurking in Finding Stories in Spreadsheets.
Enjoy!