Excel has two new functions =TRANSLATE and =DETECTLANGUAGE, now available for the CUrrent Channel of Microsoft 365, these can translate any text to another language. 3 inputs to =TRANSLATE. 1st one is the text to translate, 2nd is translate from (leave blank to auto-detect), and 3rd input is the translate to (leave blank to translate into your system language).
GOOGLE TRANSLATE for Google Sheets (or Excel if you have an older version): • GOOGLE TRANSLATE formulas for Google Sheets
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/soc...