In today’s Podcast, another guest post by Bob Umlas.
Bob has data where someone has used Alt+Enter to put multiple lines in a Cell. He wants to break each of those lines out to a new Cell. This video shows the easy trick.

Also in Episode #1837, Bob discusses a problem with the Excel Formula Bar since Excel 2007. If the Formula Bar contains more than one line, it is hard to realize that there is more to the Formula than what you see in the Formula Bar. Bob has been lobbying the Excel team to color the Formula Bar when you are not seeing the whole formula.

Array

Excel Outside the Box: Unbelievable Excel Techniques” by Bob Umlas. Think that you know everything that there is to know about Microsoft Excel? Guess again. If you’re ready for the next level of Excel, then “Excel Outside the Box” is for you! ‘Outside the Box’ is an in-depth look at 54 amazing techniques from Excel MVP Bob Umlas. Have a look at the Table of Contents Here.