Yesterday in Episode #1690, Bill looked at Totaling up hours in a schedule; originally, he wanted to show the formulas for that Podcast to the right of the work applied. Today, in Episode #1691, Bill tells us how the =FORMULATEXT Function in Excel 2013 works and then shows us how to create that same functionality for Excel 2010!
Another simple 'Beginner Project' for the aspiring Excel User looking to try a little VBA. Follow along, give it a try and see how you may apply the use of this simple Macro as you create and use your first Visual Basic for Applications Project in Excel 2010!
"Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
Another simple 'Beginner Project' for the aspiring Excel User looking to try a little VBA. Follow along, give it a try and see how you may apply the use of this simple Macro as you create and use your first Visual Basic for Applications Project in Excel 2010!
"Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Learn Excel from MrExcel podcast, episode 1691 - =FORMULATEXT() in Excel 2010!
Alright, so yesterday I was working on that formula for Leslie, and I had all these formulas here, and I really wanted to get the formulas out to the right, use FORMULATEXT.
But for whatever reason, here I am in Excel 2010, not Excel 2013, and so, we don't have FORMULATEXT.
Do I save this file, close Excel 2010, open Excel 2013, just to use formula text?
You know what, let's just do this: Alt+F11, Insert Module, and we'll create a little function here called Function FT, it stands for FORMULATEXT, MyCell as range.
And FT = MyCell.Formula , that's all what FORMULATEXT really does.
We just come out here, now =FT of this cell, copy that down, and we can see what our formulas are.
FORMULATEXT, it's a great thing I love it in Excel 2013.
Every once in a while I find myself in Excel 2010 saying "Ah, I really wish I had Flash Fill, I really wish I had FORMULATEXT." Those seem to be the two that come up again and again and again, but using this tiny little macro here will let you do FORMULATEXT in Excel 2010.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Learn Excel from MrExcel podcast, episode 1691 - =FORMULATEXT() in Excel 2010!
Alright, so yesterday I was working on that formula for Leslie, and I had all these formulas here, and I really wanted to get the formulas out to the right, use FORMULATEXT.
But for whatever reason, here I am in Excel 2010, not Excel 2013, and so, we don't have FORMULATEXT.
Do I save this file, close Excel 2010, open Excel 2013, just to use formula text?
You know what, let's just do this: Alt+F11, Insert Module, and we'll create a little function here called Function FT, it stands for FORMULATEXT, MyCell as range.
And FT = MyCell.Formula , that's all what FORMULATEXT really does.
We just come out here, now =FT of this cell, copy that down, and we can see what our formulas are.
FORMULATEXT, it's a great thing I love it in Excel 2013.
Every once in a while I find myself in Excel 2010 saying "Ah, I really wish I had Flash Fill, I really wish I had FORMULATEXT." Those seem to be the two that come up again and again and again, but using this tiny little macro here will let you do FORMULATEXT in Excel 2010.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!