How can I convert Chinese to English

Function translator for Excel

This article walks you through the steps to set up and use the Function translator-Add-ins for Excel. The Function translator is for people who use versions of Excel in another language and need help finding the right function in that language or translating complete formulas from one language to another.

The Function translator:

  • Allows users who know the Excel functions in English Be productive in localized versions of Excel.

  • Allows users translate complete formulas effortlessly into their native language.

  • Supports all localized languages ​​and functions of Excel, 80 languages, 800 functions.

  • Offers a efficient way to search for any part of the function name in both languages.

  • Shows a scrollable, categorized list English functions and their localized equivalents.

  • Allows you to provide feedback to Microsoft on the quality of the function translations. You can provide feedback on a specific function in a specific language.

  • Localized to English, Danish, German, Spanish, French, Italian, Japanese, Korean, Dutch, Portuguese (Brazil), Russian, Swedish, Turkish, Chinese (traditional), and Chinese (complex characters).

Install the Function Translator Add-in

The Function translator is available free of charge from the Microsoft Store and can be installed using the following steps:

  1. Start Microsoft Excel

  2. Switch to the tab Insert.

  3. Click the button in the ribbon Store.

  4. The Office Add-ins dialog box starts. Make sure, that Store is selected above, then click on the left productivity.

  5. Search using the search box in the upper left corner Functions Translator.

  6. When the add-in is found, click the green button to the right of it Add, and the translation aid will be installed

Configure the function translator

After installing the Function translator- Add-ins are on the far right of the tab begin two buttons created.

The buttons take you to the areas reference and translator in the dialog box Function translator. The exception to this is the first time theFunction translatorAdd-ins that take you to a Welcome page reach:

The area opens on the right side of Excel. There it is anchored for all processes.

You can jump straight to translations by clicking the> skip link on the right side at the top of the frame. However, we recommend First stepswhich takes you to the Language Settings dialog box. This allows you to use your standard Of- and In languages you can change it at any time.

Here you can configure your language combination. The Function translator supports all languages ​​for which Microsoft provides localized Excel functions, but you can now work with one language pair at a time. Any language combination is possible and Excel will remember your choice. The language pair can at any time via the area Settings accessed from any of the main areas of the add-in.

By default, the Of- and In-language already with English as the source language and the language Excel installation as Target language filled up. If the installation language is one of the languages ​​we localized for the functions translator to have,the user interface is displayed in the localized language. click You start at work, when you have selected the language pair.

We use the concept of source language in the translator (Out) and target language (In). The Target language is the language you know that Source language is the language you are looking for. So, for example, if you were researching reference functions in English but needed the French function names, you would use the Source language in English and the Target language set in French.

With the help of green arrow between the fields "Off" / "In" you can easily switch between the Source language and Target language switch.

Settings

You can use the area Settings by clicking on the gear icon at the bottom of the three main areas.

Not only can you provide various links here that may be of interest, but also their to and From languages change anytime. If you are up in the area clicking the left arrow will take you back to the main area.

The "Reference" area

The "Reference" area contains a drop-down list for the Function category, and below that all functions of the respective group are shown on the left in the Source language and right in the Target language displayed. If you are not sure which category a function belongs to, you can use the option All choose.

By default, the functions are sorted alphabetically according to the column of the Source language sorted, in this case English, shown here with a small downward pointing arrow next to the word "English". You can sort alphabetically or alphabetically backward, and you can sort by the Source language or the Target language sort by. Just click the language you want to sort by and click the name again to reverse the sort order. The arrow indicates the sort order.

Clicking on the name of a function in one of the columns will take you to the area dictionary, in which the function is displayed with a brief description.

The "Dictionary" area

in the Area Dictionary allows you to search for any part of a function name by displaying all functions that contain the letters entered. For performance reasons, the search only fills in results after you have entered at least two letters. The search will appear in the language pair you selected and return results for both languages.

Once a search returns the name of the function you want, you can click on it and the language pair and definition of the function will appear. If you click on the name of a function in the field reference you will also get to the dictionary, and the language pair and description of the function are displayed.

Hints:

  • Descriptions are not available for all functions, but very few are missing.

  • The descriptions of the functions are only available in English.

  • If you need a localized description, you can go to the Formulas tab, click the appropriate function category, and point to the function in question. Excel displays a description of the function in the language of your installation.

If you click on the lightbulb icon in the area dictionary Click to go to the area Translation feedback, in which you can give us your feedback on a specific translation.

The translator area

In the area translator you can translate a complete formula from one language to another. Here is an example of the range translator, in which a formula was translated from English into French:

The source language (Out) and in the lower field the target language (In) is displayed. With the two buttons with the green arrows in the middle, you can determine the translation direction. In this case we have a formula in the field Out and clicked the down arrow to translate the formula into French.

Manual definition of the separator

Excel functions use separators to separate ranges and arguments. Different separators are used in different languages. Although the function translator tries to make the right selection, it may sometimes be necessary to set some separators manually.

Under each Out / In field there is a group of buttons as shown above. The first button copies the entire content from the text field above and pastes it into the currently active cell in Excel. Use this button to insert a localized formula into a desired cell.

The other buttons are grouped according to their respective functions: The Decimal separator, the Matrix separator and the List separator.

  • Decimal separator

    • The decimal separator can either be a point or a comma.

  • Matrix separator

    • This separator is intended for matrix formulas.

  • List separator

    • For English, the decimal separator is usually a period and the list separator is a comma. In some European languages, the decimal separator is a comma and the list separator must therefore be something else, namely a semicolon.

Immediately translate selected cell

The option Immediately translate selected cell on the tab translator tries to translate the formula in any selected cell. The formula is transferred from the marked cell to the lower language field In inserted, and immediately a translation in the language fieldOut displayed.

Hints:

  • The feature Immediately translate selected cell is not supported in Microsoft Excel 2013 or earlier versions.

  • The feature Immediately translate selected cell does not work when you are in edit mode in a cell. As soon as you exit edit mode, you can use instant translation again.

Feedback

We hope that the Function translator Will help you be more productive with the localized versions of Excel, and we'd love to hear your feedback. Send us your feedback on functions for which the translation quality is not yet optimal, but also on the add-in itself.

If you have an opinion on general localization of functions and how this add-in should work, we'd love to hear those thoughts too!

The function translation team, Martin and Vadym

[email protected]

Note: We will personally review each and every feedback, but we cannot guarantee that we will respond to every post. Please do not add files that contain personal information.

Do you need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers Community.