In today's podcast, another guest post by Bob Umlas. First, Bob talks about a problem with multi-line formulas in the Formula Bar and suggests that Microsoft needs to solve the problem. Next, an easy way to unwind multiple lines created in one cell using Alt+Enter.
To read more about Bob's book: Excel Outside the Box
To read more about Bob's book: Excel Outside the Box
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast episode 1837.
Bob Umlas Unwind Alt+Enter in a Cell.
Hey, welcome back to the MrExcel netcast.
Today I have another tip recorded by Bob Umlas out at the MVP Summit.
First Bob is going to show us a problem with a formula bar and then on to the tip.
All right, Bob.
Hi! This is Bob Umlas talking to you from the MVP Summit and we're at good old Washington State.
There's a couple of weird things going on in here, if I click on on cell A1, I see that the formula says today.
So, it says False for the function TODAY and that doesn't make any sense whatsoever, but one thing that I have asked Microsoft to do in some version is when there's a multiple line, you can see over here that there's formula bar has more lines to it.
It says today equals 100 which of course is false, but it's not very obvious that there's something hidden and my tip is to call it this whole bar of some sort of color.
So, it's obvious that something else is going on, anyway that's that one.
Here, I have just the word Now, but you can also see that it has the there's more stuff to it.
So, if I drag this down it says, "Now is the time for all good men to come to the aid of their party", and the, as you can tell us the text to columns.
I'd like to expand this until now is the time etc, but the question is how do i do that, If I go to Data, Text to Columns, it's certainly not fixed with.
So, it must be Delimited next, but what is the character I can't put in a new line symbol here.
So, it is other, but oddly and I don't remember how I found this out, but control+J does the trick and as you can see it did it I just click Finish and we're done.
So, that's a pretty cool thing.
if you have spacing like that.
Okay thanks.
All right, that is a great trick control+J, I always figured it was J because J, is the tenth letter of the alphabet and the Alt+Enter is putting in a character 10 that may not be true that's just the way I always remember it.
So, check out Bob's book Excel outside the box lots of amazing techniques for doing great things in Excel.
We'll see you next time for an other netcast from MrExcel.
Learn Excel from MrExcel podcast episode 1837.
Bob Umlas Unwind Alt+Enter in a Cell.
Hey, welcome back to the MrExcel netcast.
Today I have another tip recorded by Bob Umlas out at the MVP Summit.
First Bob is going to show us a problem with a formula bar and then on to the tip.
All right, Bob.
Hi! This is Bob Umlas talking to you from the MVP Summit and we're at good old Washington State.
There's a couple of weird things going on in here, if I click on on cell A1, I see that the formula says today.
So, it says False for the function TODAY and that doesn't make any sense whatsoever, but one thing that I have asked Microsoft to do in some version is when there's a multiple line, you can see over here that there's formula bar has more lines to it.
It says today equals 100 which of course is false, but it's not very obvious that there's something hidden and my tip is to call it this whole bar of some sort of color.
So, it's obvious that something else is going on, anyway that's that one.
Here, I have just the word Now, but you can also see that it has the there's more stuff to it.
So, if I drag this down it says, "Now is the time for all good men to come to the aid of their party", and the, as you can tell us the text to columns.
I'd like to expand this until now is the time etc, but the question is how do i do that, If I go to Data, Text to Columns, it's certainly not fixed with.
So, it must be Delimited next, but what is the character I can't put in a new line symbol here.
So, it is other, but oddly and I don't remember how I found this out, but control+J does the trick and as you can see it did it I just click Finish and we're done.
So, that's a pretty cool thing.
if you have spacing like that.
Okay thanks.
All right, that is a great trick control+J, I always figured it was J because J, is the tenth letter of the alphabet and the Alt+Enter is putting in a character 10 that may not be true that's just the way I always remember it.
So, check out Bob's book Excel outside the box lots of amazing techniques for doing great things in Excel.
We'll see you next time for an other netcast from MrExcel.
