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

Ask a question

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
Jean-François Pillou

Jean-François Pillou - Founder of CCM
Better known as Jeff, Jean-François Pillou is the founder of CommentCaMarche.net. He is also CEO of CCM Benchmark and digital director at the Figaro Group.

Learn more about the CCM team