The first is a basic translation of several cells in Excel, while the second example shows you how to use the TRANSLATE function dynamically with a drop-down list.

Writing Excel formulas isn't easy if you don't speak the language. Fortunately, at least two sites will translate your request, in English, into Excel code.

Discover the new Excel TRANSLATE & DETECTLANGUAGE functions, enhancing global communication directly in your spreadsheets.

The TRANSLATE () function in Excel allows users to translate text from one language to another directly within their spreadsheets. This can be very useful for multinational brands and foreign ...

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.