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.