Fixing Messy Excel Data made easy by Flash Fill

Everyone who uses Excel one-time or another had the problem of messy data. In this video Mynda shows how to use 'Flash Fill' and thereby how to split, reformat and combine columns of text with an easy keyboard shortcut.