Excel Introduces TRANSLATE and DETECTLANGUAGE Functions - Episode 2645

Excel Introduces TRANSLATE and DETECTLANGUAGE Functions - Episode 2645

MrExcel.com

3 месяца назад

2,380 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@suatmozgur
@suatmozgur - 10.07.2024 16:37

Bravo, Excel Team! 
Thanks for the video, Bill!

Ответить
@GeertDelmulle
@GeertDelmulle - 10.07.2024 16:42

Nice to have.
It would be better if MS would make sure that wherever we can enter ranges as input, we can enter arrays as well.
And I mean: without restrictions (looking at you AGGREGATE).
(Indeed, a missed opportunity to translate the function names, but who knows that may come next)
Thanks for the heads up, Mr.Excel. :-)

Ответить
@daustonian9331
@daustonian9331 - 10.07.2024 16:47

How fantastic and needed for the past 20 years. Thanks for the quick intro!! I have to think they will keep updating it… we hope. Competition is good

Ответить
@RadAlzyoud
@RadAlzyoud - 10.07.2024 18:06

The Arabic translation is accurate.

Ответить
@ennykraft
@ennykraft - 10.07.2024 19:08

I'm German and - well - let's say there's room for improvement. People would understand what you're trying to say but the grammar isn't very good and the colloquialisms don't work in same cases. For example in German you wouldn't say It's Bill, you'd say I am Bill.

Ответить
@coco99ca
@coco99ca - 10.07.2024 19:32

I'm going to keep an eye out for this thanks

Ответить
@ricos1497
@ricos1497 - 11.07.2024 11:18

Bill, I don't have this function yet. What's Mexican for "build a wall"? Asking for a friend.

Ответить
@jerrydellasala7643
@jerrydellasala7643 - 11.07.2024 19:22

The TRANSLATE function uses the System's default language for either option. If the text is not the System language, it will automatically detect the language (no need to use DETECTLANGUAGE) and translate it into the System Language. The formula =TRANSLATE(C3) worked fine on the ManyLang Worksheet in your sample. (credit Leila Gharani for that!).

Ответить
@rubenmunozverdu7528
@rubenmunozverdu7528 - 12.07.2024 14:56

Is that function connecting to some kind of server under the hood? I mean, do you need internet connection for the function to work?

Ответить
@Maxwell-237
@Maxwell-237 - 15.07.2024 03:55

Looks like Hindi has it's own word for Excel?

Ответить
@jimtaylor4813
@jimtaylor4813 - 05.08.2024 20:24

Can someone here help me? I am looking to take an Excel course and earn a certificate. I also don't know what to do regarding Data Analysis, Business etc?

Ответить
@TonyDiem
@TonyDiem - 07.08.2024 18:52

When can I expect to see this in my Excel? I just tried it and it's not working. . .yet?

Ответить