Using Excel's Transform Data By Example Add In
Excel's Transform Data by Example add-in is a GREAT tool for cleaning up your data in instances where Flash Fill simply won't do the job. Check out this video to learn how you can take advantage of this feature!