Today Bill looks at using ‘Text to Columns’ to split up Data in a single Cell. In this Learn Excel from MrExcel Podcast, Bill shows us the use of =LEFT, =MID, The ‘Flash Fill’ feature in Excel 2013 and more. Follow along with MrExcel in Episode #1706 as he designs a means to achieve splitting Data from a single Cell.

[youtube=http://youtube.com/watch?v=Lps1z_RxsWo]

"Excel 2013 InDepth" - by Bill JelenMicrosoft 2013 InDepth” – by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013.

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!