Learn Excel 2010 - "=FORMULA TEXT() in Excel 2010": Podcast #1691

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Apr 18, 2013.
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
maxresdefault.jpg


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!
 

Forum statistics

Threads
1,223,698
Messages
6,173,901
Members
452,536
Latest member
Chiz511

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top