Zehad Rian Jim
This tutorial will demonstrate how to translate Arabic to English in excel. In this modern era, global communication and trading have become very important. But it is very evident that one can’t take possession of every language. So, it is very important to learn to translate one language to another in excel. In this article, we will try to translate Arabic to English in excel. Please follow the article thoroughly to enjoy the journey of this learning.
Download Practice Workbook
You can download the practice workbook from here.
Step-by-Step Procedures to Translate Arabic to English in Excel
Our target is to translate Arabic to English in excel. For fulfilling that purpose, at first, we’ll use a sample dataset overview as an example in Excel to understand easily. Then, we will gonna use the Translate option in Excel. This option will translate the desired cell values from Arabic to English. If you follow the steps correctly, you should learn how to translate Arabic to English in excel on your own. The steps are
Step 1: Arranging Dataset
In this case, our goal is to arrange a dataset that will be further used to translate Arabic into English. In this instance, we have Arabic Sentence in column B and an English Sentence in column C. We have managed some of the famous used Arabic sentences and put them into column B for our usage.
Step 2: Using Translate Option
After arranging the proper dataset, we will aim to translate Arabic sentences to English in excel. To do so, we will take the help of the excel built-in Translate option. The Translate option is very important in Excel. It can easily convert one language text into another language text. It is not only used but also very helpful while trading or communicating with foreign businesses. Let’s describe thoroughly how to use the Translate option for achieving our aim.
- Firstly, select the whole data range( in this case whole column B) that you want to convert.
- Secondly, right-click on the selected data and select the Translate option from the context menu option.
- Thirdly, you can alternatively select the Translate option from the Ribbon Select the data > Review > Translate options to do the same work. It is similar to the previous step. So, you can use any of the steps.
Read More: How to Translate Excel File to English (2 Easy Ways)
Step 3: Showing the Final Result
In this portion of the article, we want to show the final outcome of the excel. The description is below.
- To begin with, after using the Translate option, at the right side of your window, you will see a Translator portion has opened on the screen. In the From option select the source data language( you want to change) and in the To option select the desired language( you want the data to be changed into). In this case, we have tried to convert Arabic into English and got the below result.
- In addition, then press Ctrl+C to copy the value from the Translator window and Ctrl+V to paste the value in the desired cell( in this case cell C5). Remember that you have to press the copy and paste every data individually.
- Finally, if you have copied and pasted every data in excel then you will get your desired result.
How to Translate English to Arabic in Excel
Our target is to translate English to Arabic in excel. For fulfilling that purpose, at first, we’ll use a sample dataset overview as an example in Excel to understand easily. Then, we will gonna use the Translate option in Excel. This option will translate the desired cell values from English to Arabic. If you follow the steps correctly, you should learn how to translate English to Arabic in excel on your own. The steps are
Steps:
- First, our goal is to arrange a dataset that will be further used to translate English into Arabic. In this instance, we have Arabic Sentence in column C and an English Sentence in column B. We have managed some of the famously used English sentences and put them into column B for our usage.
- Secondly, you can alternatively select the Translate option from the Ribbon Select the data > Review > Translate options to translate English to Arabic in excel.
- Thirdly, after using the Translate option, at the right side of your window, you will see a Translator portion has opened on the screen. In the From option select the source data language( you want to change) and in the To option select the desired language( you want the data to be changed into). In this case, we have tried to convert English to Arabic and got the below result.
- Lastly, if you have copied and pasted every data in excel then you will get your desired result. And that’s how excel data can be translated from English to Arabic.
Read More: How to Translate Language in Excel Formula (with Easy Steps)
Things to Remember
- In the 2nd step, for selecting the Translate option, we have shown two methods. You can use any of the methods to do the work.
- After using the Translate option, you will get the result in the right-side Translator window at first. But this is not permanent. If you go to another data value it will show the result for that value. So, you have to copy and paste the translated value into your excel.
- We have shown the steps for Arabic to English. But you can apply to translate any other language too.
Conclusion
Henceforth, follow the above-described methods. These methods will help you to translate Arabic to English in excel. We will be glad to know if you can execute the task in any other way. Follow the ExcelDemy website for more articles like this. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our level best to solve the problem or work with your suggestions.
