You are reading the article How To Translate Text In Excel With Examples? updated in September 2023 on the website Khongconthamnam.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested October 2023 How To Translate Text In Excel With Examples?Introduction to Excel Translate Function
Excel Translate is a powerful in-built function to convert any word or sentence into several languages. This tool is ideal for professionals working across different native languages.
Moreover, it facilitates effective communication by sharing documents with colleagues and business partners in multiple languages, enhancing readability and preventing confusion.Where is the Translator in Excel?
In Excel, the “Translate” feature is available under the “Language” section of the “REVIEW.”How to Translate in Excel?
Let us learn how to translate words and sentences from one language to another with the help of the following examples.
You can download this Translate Excel Template here – Translate Excel TemplateExample #1
Step 2: Type the word you want to convert and select the”Fro” and“T” languages from the options. For example, type Today and select English in From and Hindi in the To section. The result will display automatically.
Note: The Swap option of the translator function can be used to interchange the To and From languages.
Note: You also directly select the cell you want to translate. The selected text will display automatically in the upper box. Then you have to choose the target language. Text is immediately translated into the target language, as shown below.Example #2
Suppose you have the below data of some words in English, and you want to translate those words into another language like Chinese and French.
The result will be displayed in the menu as shown below.
Note: Remember that the translated words will only appear on the menu. You have to copy-paste the translated word into their respective cells.
Step 4: Repeat the same procedure for Chinese and French.
All the words are now translated into different languages, as shown above.Example #3
You can also change a long sentence from one language to another. For example, there is a long sentence in English -“Hello, my name is David. I love cooking and listening to music. “You want to translate this sentence into French.
Type the above sentence in the From section and select French in To. The output is shown in the image below.How to Install Functions Translator Add-Ins
Follow the below procedure to install the Functions translator in Excel.
The Function Translator is installed successfully. It will appear at the bottom, as shown below.
The function Translator will appear in the Home tab. It will have two options: Reference and Translator.
A language settings dialog will open. This dialog box allows you to select From and To
Step 8: Select From and To languages.
To is the language you know and are familiar with, and From is the language you want to find or translate. Note: You can change the language anytime through the Preferences pane. The swipe button, represented in an up-down arrow, allows you to switch the language easily.
For example, if you know French and want to translate Excel formulas into English. You can select English in the From and French in the To, as shown below.
Step 10: Enter the formula you want to translate.Things to Remember
The shortcut to open the translate window is Alt + Shift + F7Excel’s’s translator result may be prone to errors and inconsistenciesExcel’s translator is mainly suitable for personal understanding.
The translated text or sentence may not be ideal for professional use.
You should have an internet connection to access the Excel function translator.
You can search for the Excel function under the dictionary of Function Translator.Recommended Articles
This article is a guide to Translate in Excel. Here we learn to translate text to different languages using Translate in Excel and how to add a translate option in Quick Access ToolBar. You can also go through our other suggested articles –
You're reading How To Translate Text In Excel With Examples?
Update the detailed information about How To Translate Text In Excel With Examples? on the Khongconthamnam.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!