Learn Excel Episode 479: Parsing Irregular Text

Posted in Companies, Podcasts on July 07, 2008


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

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel