Excel - Language Translation: a Better Solution Using Power Query - Episode 2510

Thanks for the video, the built-in translator works well. If you copy, paste special in the destination cell and select text, the data populates in the corresponding cells

This was fantastic. Did not understand the code, but was able to follow along and change as needed. Liked and subscribed. Thank you.

wowww Such a good work. Thanks a lot Sir! You're Amazing!!!

I have english words, almost 1000, in excel and I have to write their meaning and part of speech in the other columns. Is there any shortcut way of doing this so that I have not to search individual word on google.

doesn't work :(

Cheese it a little - put a pipe "|" at the end of every line, copy/paste to a cell then =textsplit(Cell,,"|") and it will break up the lines of text to for each phrase. Not a super solution, but its A solution. Its not dynamic and only a one time deal, but if you just need to do it once.?!!

I couldn't get this to work going from English to German.. de is the text code

how do you translate from Mandarin to English?

Such a good work, well done 👏👏

Kyle e-mailed steps to solve this:
In A1:A6, put these words:

Hello
Goodbye
Yes
No
How much does this cost?
I hope it doesn't rain today.

Highlight A1:A6

Review
Translate

The translator pane should appear on the right side with the source box on the top and results on the bottom..

Now before you copy the results you use the double arrows between the boxes to flip the contents.

Next you will be performing actions on the contents of the top box with the translations rather than the bottom box.

Copy and paste the translations to B1 and they should paste the next to the proper items.

If you want to translate more after doing this once don't forget to click on the double arrows to switch the boxes back again before selecting more items. You may also have to click in the top box again to get it to translate again.

this is great! what is the character limit?

Bless u ❤❤❤❤❤

Like

Oh ...Excel still needs some improvements

Thanks, Bill for the workaround. Excel inbuilt WEBSERVICE function with some LEFT and REPLACE functions would do the job here.

Thanks, Mr Excel!!!!

PQ to the rescue. Wonder why a Language Translate option can't be incorporated into the Data Types section on the Data tab in the ribbon.

Cool Bill- where would one get a list of language abbreviations?(En/Es etc).. with a bit of mucking around with a custom function it should be possible to toggle input and output languages.

Thanks Bill. In google sheets there is a very simple but effective function =GOOGLETRANSLATE(B4;"nl";"en"), I wonder why this is not in Excel......

Power query es una maravilla.

It would be awesome if excel could distinguish between languages.
Like for instance I have a column with mixed languages and want to sort it that one language is first and underneath each other then the next language

All power to Power Query! Nice one, Mr Excel.