Download the Excel practice file I use in the video here 👉 pages.xelplus.com/excel-translate-file To understand how a new function gets rolled out by Microsoft: www.xelplus.com/excel-versions/

Confirming that the Greek translation is accurate. Thank you again for one more great tutorial and for all you do for the excel and the entire business community!!

Great! I wrote an Azure Cognitive Services translator 3 years ago for Excel! Good to see Microsoft catching up!

I am greek and the translation is correct! Thank you so much for your videos!

This formula will help me a lot. Right now in order to automate the translation in a file I have created a mapping from english to Greek which is massive. Thnx Leila :)

Absolutely brilliant - I can’t believe it has taken Microsoft this long to introduce this function. I will be using it to help with me studying Portuguese

Excellent function and very well explained. Thank you Leila!

This is what ive been waiting for. Thanks

Useful function very well explained! Thank you, Leila! Greetings from São Paulo, Brazil!

Thank you always for keeping us abreast

So cool. Before watching this video, I just know use translation machine like Google Translate or Immersive Translate to help me translate what I need. But now, I have known a new tool to help me translate Excels. Thanks for your sharing ❤.

Awesome new stuff. Thanks for sharing.

That’s really useful for those who work in places where there are teams in different countries!

A much needed formula from long time👍

You're The Best in the world👍🏻👍🏻👍🏻 I wish I could use excel like you do😅 Constantly learning from you, keep up the great work😍😍😍 Thanks for sharing👍🏻👍🏻👍🏻

Tnx love from Bangladesh 🎉

Great feature. Hope this arrives soon to our tenant. Usually it takes a year.

Looking forward to this release as it will help me with my mobile application translations

Looking good (as always).

Always cool The best channel

Happy to learn

Amazing function thanks Leila, also can we have a seriece of sessions about Macro learning, i am exited and realy need Macro in my job, but do not have the foundation to start.

Thank you 😊

This is great, I go between English, German and Spanish all the time! And BrBa is also my favorite show!

Great feature!

Thanks for the great content as always.

Very cool ... and once again have Prof Leila to thank for bringing it to my attention ... thank you ... 😍

Thank you for your good Information.

THX.

AWESOMEEEEEEE!

very insightful

That's neat. Could have used this years ago working internationally on migration projects.

Hi Leila , I can assure you that Greek translation works great ( word of a Greek guy LoL) . By the way it's always a pleasure watch your videos

As always you show us the best of new functions in a very clear way. The question I was asking myself was.... "What if I don't know what source language is?" The text I will translate is in A1, C3 has the language I want the formula to translate, and sheet2 b2:b10 has the table of languages. The answer I came up with is this: =TRANSLATE($A21,DETECTLANGUAGE($A21),XLOOKUP(C$3,Sheet2!$A$2:$A$10,Sheet2!$B$2:$B$10)) Did I forgot to say I'm your fan?

Pretty neat function. Now MS needs to create a similar function (or functions) that can change date and time formats based on national standards.

This is what GSheets better had over Excel... so happy it's landing on Excel now too

Thanks Leila

Great ❤❤❤

That is pretty cool. I just hope that the TRANSLATE function is added to Excel 365 for Mac pretty quickly. [EDIT] It came in this morning so, very nice!

Many thanks for showing us how to use this great new function. Do you have any information when this will be available for normal office users?

I will love it for translating my datasheets!! Actuel I work with formulars …. pffff …. 😅

Yay! so excited for this to come to Excel so I don't have to go over to google. I use this for translating survey questions/outlines to import into Forms. Hopefully one day, Forms will do the auto translating for me!

Ur looking nice keep up

Another awesome video! Thank you Professor Gharani! I honestly don’t know how I’ve managed my Excel production for so long without your expertise, clarity in explanations, and incredible insights and tips! Thank you truly!

It would be very useful for this dynamic functionality to be ported over to Word,

I'm surprised by how accurately it translates the input!

what version does this function come with please I don't seem to have it on my latest version

Thank you Leila (Y)

Hi Leila , just confirming all these updated video are they also updated in your black belt course as i have unable to find all those updates.

Need this for outlook lol

i have office 365 but i don't have translate function although i have updated it but don't have it!

This is cool, I should probably learn how to use excel first 😅

pretty cool! thanks for the tutorial, but you didn't mention if this fomula relies on internet or use built-in dictionary.

It seems as if in a lot of the formulas in this video, as shown on the screen, there are unnecessary space-characters before and after commas (where the comma is a delimiter between arguments of a function). Again, what SHOULD happen if such a Cell-Entry is attempted is that Excel should balk, some kind of error-message or error-result in the Cell. The reason this is so important is a colleague of mine who lost half a day's work trying to work with text formulas. What she SHOULD have typed was something in the pattern of =SUBSTITUTE(A4,"Buyer",D4) to replace the word "Buyer" in a sentence in Cell A4 with the word in Cell D4. But Excel's toleration of errant space-characters had left her with some sort of vague sensibility or impression (not probably the most conscious of thoughts) that the commas that are used as delimiters are like the U.S. English commas in "red, and white, and blue". They're not. One must WISH that Excel had used some other character as a delimiter, such as the pipe ("|"). Then this confusion wouldn't have been created, and she'd have typed =SUBSTITUTE(A4|"Buyer"|D4) correctly the first time. But because of the U.S. way of doing punctuation in English, she kept on trying things like =SUBSTITUTE(A4,"Buyer,"D4) in the belief that U.S. English grammar requires the comma to go INSIDE the quote-mark. Since the text "Buyer," (ending in a comma) didn't OCCUR in Cell A4, and since the SUBSTITUTE function doesn't give any indication of anything awry (nor should it) if the sought-for text isn't found in the text in question, all of her SUBSTITUTE-formula Cells contained the exact text as the Cell they were working on. And she didn't notice it until hours later. Then she got a bit frantic and thought the failure was owing to missing space-characters (which would also be required in English grammar), so, in vain she tried correcting to =SUBSTITUTE(A4,"Buyer," D4) and =SUBSTITUTE(A4,"Buyer, " D4) and other combinations of things that didn't work. If Excel had been intolerant of confusing commas-as-delimeters with commas-in-English-grammar, and therefore intolerant of any notion that such commas need space-characters, she'd never have gone down the wrong road of unconsciously believing that the two should work the same way with respect to quote-marks that end literal text, and she wouldn't have had to scramble with the deadline and rush the fix once I arrived with the explanation.

Your videos are amazing what is the settings you use for exporting please

Leila thanks so much for your very helpful videos, I've been trying to set a formula in excel 365 to return last selling price of each product for each customer to be used for their returned items, can you help me? bearing in mind that each product has various selling prices based on customer and selling date. Thanks a lot

need more videos on powerbi

Good video and demonstration of the new functions. But I’d rather have full (dynamic) array support in all functions, including in data validation and conditional formatting. That’s a repeat statement, I know. ;-)

this is best function. how to have this function in my excel?

Does TRANSLATE create dynamic spilled arrays? Nice new feature!

Some programming systems allow the usage of lookup tables for localization. Each row would have the text to show in the relevant button or window, and each column would have the translation for the enduser's selected language. Is there a way to have placeholders that should not be translated besides using quotes, such as [COMPANY NAME]?

Hi, is their a way to get the 'Date Taken' from a Picture, using VBA, So as to create a List of 'Picture Names' & 'Date Taken' ❓ P.S. Love your Videos ❤️

This will be super useful for forms and policy documents. When is this feature being released?

Translation of acronyms??? For example, SWOT = Strengths, Weaknesses, Opportunities, and Threats. What about a dictionary of proprietary abbreviations / acronyms? And going between languages? I deal with this on an almost daily basis for work (foreign automaker + 2nd country foreign supplier, both in yet another country). I’m interested in seeing this work!

The translation in Greek is absolutely correct!!! 🇬🇷 🇬🇷 🇬🇷 ❤

This is how i export the outlook calender: File > open & export > import/export > export to file > comma seperated values > calendar. How do you do that in the new outlook?

What an amazing addition! Does the new function include Arabic?

i have this in my excel

Is this only for Enterprise customers? I am on the version you list in the description and in the Beta Channel. Also will this feature work offline? Thanks for this video. It's great.

Video is good, translating can be useful as viewed in the video, just never thought about how useful it could be. Question would be, how accurate are the translations from one language to another? 😺👌🥰 👩‍💻⭐️💎

Wouldn't it be cool if there was a formula to change from future tense to past tense? That would allow my to complete the pre-conference request form and automatically complete the post-conference report.

💚💚💚

There are three (3) points I will ask you about. My version of Office is the latest version 2024: 1- How do I get a “translate”? She doesn't exist 😮 2- Also, the new “Check Box” does not exist 🤔 3- In the latest update to Office, an icon disappeared. This icon is at the top next to Exit, which collapses the top menus to enlarge the workspace. It has three options and looks like an arrow, as I remember. It is very important. Why did it disappear? ✨ ................................................................................................ There is another topic regarding delaying the function. I asked you about it and you answered that by using VBA, I wanted to do without VBA. I wish this task existed in Excel without Vba 🤩🤗

Hi Leila Do you know when the Group By Function and Check box feature going to be in 365 Office version ( Not Insider ) Thanks

How add home tab analyze data please help me?

Dear Leila, I have a problem with Pivot Table. Every Month I update the header of resource, my Pivot Table resume usually disappear and I have to move header I want to make resume into sum column on the bottom right column. The trick I do is to make second row as template and first row as header I can change every month. I never change the second row. And I insert one line in the top of Pivot and I make a formula connected to header I want to change. If you have alternate trick, please to let me know. Thank you so much Sorry, if my question is not related to your content

Thats cool but now when will excel allow the usage of the English function names in German localized version of excel? I’m sick of having to keep those function names lists up to date with every new function added to excel. Like your videos. Cheers

if it is a living document where team members are inputting information into the spreadsheet, in order for the translation to continue working, would they have to input it in the hidden cells where the text lives? Or can they put it where the translated part is displaying?

Does TRANSLATE require internet connectivity? Is it doing the translation locally or via the net?

A very useful case. Does excel need Internet access to translate?

Hello leila, could you please tell me how to combine text and number in one cell . noted that the cell will be A1 AND A2 (A1 TEXT AND A2 NUMBER ) HOW TO DEAL WOTH THIS CASE

I think there is issue when use translate function to translate date, even the cell in date format, translate function will change it to value I mean if S6 = 1-Jul-2024 (date format) and when TRANSLATE(TEXT($S$6,"en","ar") the result is 45484. I fix this issue by using text function for example =TRANSLATE(TEXT($S$6,"dd mmm yyyy"),"en","ar") I assume S6 = 1-Jul-2024 conclusions translate function lead to mute format text

Does it send all data to the cloud and require online connection to open the files?

Cool, so it'll be out on two years time

Isn't reverse translation a possibility to check?

I wonder if this Function is running locally or running over the internet... I don't think we have local translation files for excel...

Using Office 2024 I made some changes to the same work in the video to support Arabic but it stopped working for all languages!!! Any idea why?

How to get the translate function please, as it's not on my excel spreadsheet 😢

I have download the file but it seems in a protect view and I cannot make any changes, please advise

Let´s try: "Sim o video foi muito útil, resta saber que versões já incluem esta função" Have you understood or the translate function will come to use?

With machine translation, there is of course the risk of hidden errors, but compared to having to maintain multiple sets of the same text, the benefits probably outweigh the downside.

how to enable this function excel 2019

Makes another bit of the add-in I wrote to use Azure Translation in formulae redundant :(

How do I update my excel? I've the office 365 and pay yearly but I don't have this function yet.

I’ve checked for the translation feature in my Microsoft 365, but I couldn’t find it. Is an update required to access this function?

Is there also a list of available languages (codes) that you can use in the dropdown box?

Hello, my Excel doesn't have the Translate function, I have discovered. How can I get it on there in my Microsoft Surface laptop?

Unfortunately excel doesn't recognize the translate formula, i also tried to add this formula, but it dudn't work. I guess i need a newer version of excel maybe?

Hi, i am using Excel 365 Update ver. i can not find this funtion. please guide me how to insert this function

This is really cool, but when will they provide a function translation function? What I mean is the function SUM() is what in italian, french, german, etc.. This would really be game changing for people working in a multilingual environment...