Forum Discussion
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.
9 Replies
- 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.Looking forward to when the functions become available. Is this the best channel to tune into for availability?
Thanks
John
Best or not depends on goals.
- Being on Beta we have new functionality earlier than people on other channels.
- Beta is stable enough, we practically have no crashing files and like, not more than on other channels.
- On Beta most probably we loss compatibility with people on other channels and, if we are lucky to be in first wave, with other Beta users
- Functionality introduced on Beta could be changed more close to production. That could be modified functions behaviour, moving of some features on separately paid subscriptions and / or differentiation of functionality for consumer and different levels of business subscriptions.
As a comment, new feature could appear even without weekly Beta update. Code is already within the build. If no changes which could affect functionality it could be activated any time. Or deactivated for all users, includes ones who had it, if critical bug appears.
The only we are to be on internet.
But yes, usually it is synced with new builds publishing.
Thansk Patrick2788 and SergeiBaklan ! That makes sense.
- 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.
