0
Thanks

A few words of thanks would be greatly appreciated.

Excel - How to translate formulas (from French to English)



Excel - How to translate formulas (from French to English)


Introduction

It is not always easy to translate complex formulas, especially if they are written in French. In this trick we will make use of the VBA/Excel interface ( but without adding code any to your workbook) to translate formulas.

Procedure:

  • Enter your formula in the Excel sheet,
  • Validate this formula,
  • Select the cell that contains your formula
  • Press ALT + F11,
  • Press Ctrl + G,
  • In the Run window, type:? ActiveCell.Formula
  • Press Enter

The formula has been translated to English ...

Example:

1-Enter your formula in the Excel sheet

2- Confirm this formula

3. Select the cell that contains your formula

4- Press ALT + F11, followed by CTRL + G

6- In the Run window, type: ? ActiveCell.Formula

7- Press Enter
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team

Original article published by . Translated by jak58. Latest update on by deri58.

This document, titled "Excel - How to translate formulas (from French to English)," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).

0 Comments