Another Podcast from the series: "Things that I Learned at Trainertage", by Bill 'MrExcel' Jelen. For more information and previous Episodes from this series, refer to Podcast #1632.
Today, Bill looks at Translating Formulas - a trick learned from Dietmar Gieringer while Bill was attending the 8th annual Trainer Days [Trainertage 2013 event] in Lucerne, Switzerland. Last week Bill looked at the fact that Excel 2010 does not have 'Formula Text' and thus he created a quick Function in VBA to provide the equivalent of Formula Text. Now, this solution is wonderful - if you want English; what if you wanted to see the Formula Text in another language? Use MyCell.FormulaLocal instead of MyCell.Formula. Follow along with Episode #1694 and see how easy this foray into Visual Basic for Applications really is!
"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! 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Today, Bill looks at Translating Formulas - a trick learned from Dietmar Gieringer while Bill was attending the 8th annual Trainer Days [Trainertage 2013 event] in Lucerne, Switzerland. Last week Bill looked at the fact that Excel 2010 does not have 'Formula Text' and thus he created a quick Function in VBA to provide the equivalent of Formula Text. Now, this solution is wonderful - if you want English; what if you wanted to see the Formula Text in another language? Use MyCell.FormulaLocal instead of MyCell.Formula. Follow along with Episode #1694 and see how easy this foray into Visual Basic for Applications really is!
"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! 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Here's another episode of "Excel tricks that I've learned that TrainerTage"!
This episode 1694 - Translate Formulas!
And this is courtesy of Dietmar Gieringer, that great Microsoft Excel 2010 "Idea Book" that's now out at amazon.de.
Oh hey, last week, episode 1691, I talked about, in Excel 2010 we don't have FORMULATEXT, and I showed the quick little function here, FT, that gives us FORMULATEXT.
And Dietmar said "Ah, that's really bad because all it does is, it gives us English, and this doesn't help me because I am in the German version of Excel." You know, it's a cool idea, but it just doesn't work.
But then, Dietmar did a little bit more exploring, and he created his own function, I'm going to call this Formula Text Local.
MyCell.FormulaLocal will return the formula in your own local language.
And then Dietmar goes even further, he says "Well hey, this is beautiful, next time you're coming back to TrainerTage, and you need to see the both the German and the English version versions of the formula, use =FT to return English, and =FTL to return the Deutsch." So there we go, a beautiful little way to compare the English and Deutsch.
So, for example VLOOKUP in English is SVERWEIS in Deutsch, great, great idea from Dietmar, I want to thank him for extending my idea from episode 1691.
Alright hey, I want to thank everyone for stopping by, don't forget Trainer Days, January 17 through 21st 2014, beautiful Lucerne, Switzerland, I'll be there.
Hope to see you there!
Here's another episode of "Excel tricks that I've learned that TrainerTage"!
This episode 1694 - Translate Formulas!
And this is courtesy of Dietmar Gieringer, that great Microsoft Excel 2010 "Idea Book" that's now out at amazon.de.
Oh hey, last week, episode 1691, I talked about, in Excel 2010 we don't have FORMULATEXT, and I showed the quick little function here, FT, that gives us FORMULATEXT.
And Dietmar said "Ah, that's really bad because all it does is, it gives us English, and this doesn't help me because I am in the German version of Excel." You know, it's a cool idea, but it just doesn't work.
But then, Dietmar did a little bit more exploring, and he created his own function, I'm going to call this Formula Text Local.
MyCell.FormulaLocal will return the formula in your own local language.
And then Dietmar goes even further, he says "Well hey, this is beautiful, next time you're coming back to TrainerTage, and you need to see the both the German and the English version versions of the formula, use =FT to return English, and =FTL to return the Deutsch." So there we go, a beautiful little way to compare the English and Deutsch.
So, for example VLOOKUP in English is SVERWEIS in Deutsch, great, great idea from Dietmar, I want to thank him for extending my idea from episode 1691.
Alright hey, I want to thank everyone for stopping by, don't forget Trainer Days, January 17 through 21st 2014, beautiful Lucerne, Switzerland, I'll be there.
Hope to see you there!
