Episode 308 - Parsing Colon

Joe from Florida calls in with a great question.... He is pulling data into Excel so that he can do a pivot table. However, the system sending the data is giving him both the product ID and product description in a single column. How can the data be broken apart into two columns? Episode 308 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!