Someone used Alt+Enter to enter three fields in hundreds of cells. How can this be broken into separate columns. In Episode 959, I discuss MID, CODE, CHAR, and SUBSTITUTE functions to solve the problem. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel.