Advanced

Cleaning messy data in Excel is both an art and a science. Often the same cells contain multiple types of information that need to be separated, you have garbage information to remove, or columns contain a mix of different things. Here I go through three examples of messy spreadsheets, showing some of the methods I […]