This video shows you how to use Flash Fill in Excel 2013 to join together data (concatenate); seperate out data into different columns; change the case of text and prefix and suffix data. For accompanying step by step instructions for this video see http://www.bluepecantraining.com/portfolio/whats-new-in-excel-2013-flash-fill/
------------------------