Forum Discussion
Solved
TRANSLATE() function not available in Excel
I would like to evaluate the new TRANSLATE function, but it is not available in my Excel. My Specs: Windows 11 ARM 64bit Excel version 2409 Insider Beta Channel OS and MS365 both fully updated...
- The specs look good. The reason you don't have TRANSLATE and DETECTLANGUAGE is because new features are rolled out in waves each week to the Insider Beta Channel (It seems to be Tuesday or Wednesday usually). Not everyone on the insider channel has the functions currently.
For example, PIVOTBY/GROUPBY were announced in November 2023, but I did not receive them until January. When Python in Excel was announced I received it in an update two weeks later. It varies.
I know the wait is no fun when there are cool new features coming out, but you'll get them soon enough.
Use below VBA code as a substitute for translate function Function MyTranslate(TextToTranslate As String, Optional FromLanguage As String = "en", Optional ToLanguage As String = "fr") As String Dim dict As Object Dim translatedText As String ' Replace with your own translation dictionaries Select Case ToLanguage Case "fr" Set dict = CreateObject("Scripting.Dictionary") With dict .Add "hello", "bonjour" .Add "world", "monde" ' Add more translations here End With ' Add more language cases here End Select translatedText = TextToTranslate For Each key In dict.Keys translatedText = Replace(translatedText, key, dict(key)) Next key MyTranslate = translatedText End Function
Thanks for your comment. The goal in this case is to specifically evaluate the Translate function that is supposedly released in Excel. I am trying to understand why it is not available in my Excel installation, despite being up to date and enrolled in the Beta channel.