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!


And join Bill “MrExcel” Jelen -Live and In Person- for Trainer Days: 17-January – 21-January 2014 in Lucerne, Switzerland.

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!

“The Learn Excel from MrExcel Podcast Series” — Your One Stop for Excel Tips and Solutions. Visit us today!