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!

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!

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 :)

This is what ive been waiting for. Thanks

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 ❤.

Great video. In your last formula, I had an idea that Instead of Xlookup and checking against other ranges, you could have used the switch function, that way you don't need the languages and codes in other cells. But that would probably only be beneficial when you only have a handful of languages. Xlookup would probably work better if you want to have an updateable language list.

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

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!

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👍🏻👍🏻👍🏻

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

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?

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

Awesome new stuff. Thanks for sharing.

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

Thank you always for keeping us abreast

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.

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

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?

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

A much needed formula from long time👍

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

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

Saya harus coba..terima kasih ilmunya

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

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!

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

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.

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

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!

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 🤩🤗

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

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

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.

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

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

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

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

very insightful

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

Thanks for the great content as always.

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. ;-)

Great feature!

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

Always cool The best channel

Looking good (as always).

Thank you for your good Information.

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

Thank you 😊

Thank you Leila (Y)

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

Does TRANSLATE create dynamic spilled arrays? Nice new feature!

Tnx love from Bangladesh 🎉

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!

need more videos on powerbi

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.

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?

Ur looking nice keep up

Thanks Leila

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 ❤️

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]?

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? 😺👌🥰 👩‍💻⭐️💎

THX.

Happy to learn

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

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?

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.

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

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

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

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

Need this for outlook lol

i have this in my excel

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

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

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

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

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

you should be a model ,your a stunner

AWESOMEEEEEEE!

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 do I update my excel? I've the office 365 and pay yearly but I don't have this function yet.

is the =translate() available in all verson, my office 365 is not supporting !!

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?

Isn't reverse translation a possibility to check?

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

How add home tab analyze data please help me?

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

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

thanks for the info, but why I can't use the function, I already update my excel 365, but it's still resulting #NAME? T_T

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?

I have faced a problem. i have sales qty column in multiple table. sum all tables sales qty colum as well as sales target qty. and made another measure sales qty / sales target qty. all tables has division product wise 4 years sales data. now i want to count how much product sales ach% is greater than 100% for division? can you help me?this is a powerbi dax problem

In which version of excel is this function available

Thanks very much for the video! I have been waiting for this function for longtime. I just checked my Excel 360, the function is not there yet, does it release to public?

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.

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

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