One of the most annoying things to have to do with your data is to manually clean it up. Having to go line by line in Excel to reformat names personally makes me want to scream. Thankfully, Excel has a lot of lesser known features to take care of some of those more menial tasks - including separating names stored in one column into two separate columns.