People who use Excel in several languages and require assistance finding the appropriate function in the appropriate language or even translating full formulas from one language to another can utilize the Functions Translator. This article will demonstrate how to use the google translate formula in Excel by using a function translator.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
Step-by-Step Procedures to Use Google Translate Formula in Excel
This article will walk you through how to use the functioning translator dialog box from the Review tab to do Google translate formula in Excel. So, to know more about this, you can follow the below steps accordingly.
Step 1. Making Data Set with Different Languages
Here, we have created a data set with 7 different languages such as Spanish, Bengali, Hindi, Chinese, Korean, Arabic, and Japanese, and we will translate all these languages into English for showing google translate formula by using the Translate toolbar which is the Add-ins in Microsoft Excel.
- So, you can see the below data set here with 7 different languages.
Step 2. Utilizing Translate Toolbar
In Excel, there is no built-in function to use Google translate formula. So, you can use your Review tab, where the Translate toolbar will appear. This toolbar works like a function translator to do google translate from one language to another.
- Firstly, go to the Review tab.
- Secondly, choose the Translate toolbar from the Language group.
- Therefore, a Translator dialog box will open.
- Besides, you can see here the From and To options.
- Then, you will select any language conversion google translation.
- Here, we will show how to translate different languages into English. That’s why we will select Auto-detect for any language detection automatically and English for translating it into English.
- How to Translate Chinese to English in Excel (2 Simple Methods)
- Translate Arabic to English in Excel (With Easy Steps)
- How to Translate Excel File from French to English (2 Quick Tricks)
Step 3. Selecting Language Text to Translate
In this section, we will select text in different languages and see the translation in the left-side Translator dialog box.
- Firstly, we will select the text from the B5 cell and then you will see on the right side where the Spanish language is detected.
- Then, this function translator helps translate it into English on the right side.
Step 4. Showing Final Output
In the end, we will demonstrate all the translated text in one column by using the copy-and-paste option.
- After doing Step 3 for all the text in the B column, you will copy the translated text from the Translator dialog box and paste it one by one into the D column.
- Finally, you will see all the google translations in that B column.
- If you can’t find any Translator toolbar in your Excel, then you will go to the Insert tab first.
- Secondly, you will choose the Get Add-ins option.
- Then, type Translator from the Store
- After that, click on Add.
- Again, click on Continue.
- Finally, you will see the Translator here in the below image when you go to the Review tab first.
In this article, we’ve covered Step-by-Step Procedures to do Google Translate with Formula in Excel. We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.