Easy and quick formula translation

Are you using a localized version of MS Office? Did you find a formula with the English names of functions? You can translate each function in the formula manualy or you could use Immediate window in VB editor.

1. Copy the formula to translate to the clipboard.
2. Select any cell in a sheet and paste.
3. Open VB editor (press ALT+F11).
4. Activate Immediate window (press CTRL+G).
5. Write ActiveCell.Formula=ActiveCell.Formula and press ENTER.
6. Done! You have the localized formula in the selected cell.

You can try translate this formula:

Select all

=SUBSTITUTE(PROPER(SUBSTITUTE(SUBSTITUTE("i lIKE THE MIcrisoft xc","MIcrisoft","Microsoft"),"xc","Excel")),"The","the")

Conversely, if you want to translate your formula to the English.

1. Select the cell with your formula to translate.
2. Open VB editor (press ALT+F11).
3. Activate Immediate window (press CTRL+G).
4. Write ?ActiveCell.Formula and press ENTER.
5. Done! You have the translated formula in the Immediate window.

---

---

Add-In

You can also try Excel-Translator add-in.

Tweet