Can Excel translate languages?
Part 1:
There is a built-in Translation tool on the Review tab in Excel. It shows the answers in a task pane, but it does a bad job of getting those answers back to the Excel grid.
Five new books were published this summer. Check them out at: https://www.mrexcel.com/products/
Part 2: You can use a small bit of Power Query code from Smozgur at MrExcel to solve the problem. Get that code from: https://www.mrexcel.com/board/excel-articles/using-power-query-in-excel-to-translate-data-using-the-google-translation-api.33/
Table of Contents
(0:00) Can Excel translate languages
(0:24) Translation on Review tab
(1:15) Paste back to Excel fails
(1:47) Five new books published
(3:00) Translating with Power Query
(5:12) Wrap-up