Translation To Any Language in Excel - Three Amazing Methods
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- Although English is the most commonly used language, people simply prefer their native language. This is why we need translation.
In this tutorial I show how to translate Text or Functions to any language in Excel using 3 different methods, depending upon the work situation
1- Using the built-in Translator tool.
2- Using a Microsoft Add-in
3- Using Power Query
You can Download the Exercise file and read the Step by Step instructions by clicking on the link:
officeinstruct...
I learned the basic concept for translating using Power Query by reading a post on the MrExcel Message board. Here is the link to the original post:
www.mrexcel.co...
As you will see in the tutorial, I modified the m code to make it more useful and dynamic.
Enjoy translation in Excel.