Комментарии:
All power to Power Query! Nice one, Mr Excel.
Ответить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
Power query es una maravilla.
Ответить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......
Ответить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.
Ответить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.
ОтветитьThanks, Mr Excel!!!!
ОтветитьThanks, Bill for the workaround. Excel inbuilt WEBSERVICE function with some LEFT and REPLACE functions would do the job here.
ОтветитьOh ...Excel still needs some improvements
ОтветитьLike
ОтветитьBless u ❤❤❤❤❤
Ответитьthis is great! what is the character limit?
Ответить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.
Such a good work, well done 👏👏
Ответитьhow do you translate from Mandarin to English?
ОтветитьI couldn't get this to work going from English to German.. de is the text code
Ответить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.?!!
Ответитьdoesn't work :(
Ответить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.
Ответитьwowww Such a good work. Thanks a lot Sir! You're Amazing!!!
ОтветитьThis was fantastic. Did not understand the code, but was able to follow along and change as needed. Liked and subscribed. Thank you.
ОтветитьSuper Informative!
But can we make to auto detect the source language ?
What code change should i need to do to change it to auto detect?
I did tried vise versa Vietnamese to English but it shows error.. pls assist
ОтветитьThanks for sharing. This method is very though not flexible for edit. User cannot add extra rows on it unless she repeats all the steps after the new rows added.
ОтветитьThis is great, but why is translating only the fist sentace in each cell. I have multiple sentances in each cell of a column.
ОтветитьThx !!! and help -how to translate several lines from a cell ?Translate only the first line from cell
Ответитьa life saved
Ответитьis it possible to adjust the code to have multiple languages?
ОтветитьI just translated 70k rows with this, man I owe you a couple beers.
Ответитьwhat about translating from Arabic to English i tried but no results found
Ответитьsir thank u so much for your help! its very hopeful. i also liked the video where u shared how to carry out sentiment analysis using excel. lots of love from Malaysia.
Ответитьits not working with me :(
It was saying this error:
Expression.Error: The field 'English' of the record wasn't found.
Details:
Source segment=Select the Volume button to adjust the volume of the audio.
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
Ответить