Learn Excel Episode 308: Parsing Colon

Posted in Companies, Podcasts on July 02, 2008


Learn Excel 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.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel