Episode 479 - Parsing Irregular Text

Jason sends in our question today. He has a single column of cells that contain 5 bits of information in each cell. There aren’t any good delimiters and the fields are not fixed width. To extract the necessary information from the cell, Episode 479 shows how to combine MID, FIND, and FIND to locate the important data.

This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy.