AiTranslate Function

AITRANSLATE() Description

The AITRANSLATE() function is designed to translate text directly in a cell on any worksheet.

To translate text, this function uses a large language model Google "Gemini" and can be used in any formulas both independently and in conjunction with other standard functions.

You can also use the classic function GOOGLETRANSLATE(), which uses the website "Google Translate" for text translation.

Main Characteristics of the AITRANSLATE Function

Syntax:

=AITRANSLATE(Text; Language)

Parameters:

• Text: A cell with text that you want to translate into another language.
• Language: The language you want to translate the text into.

Example of Use

Suppose you have a cell with text you want to translate. You just need to enter the AITRANSLATE() formula, and Excel (Calc) will automatically translate the text:

=AITRANSLATE(Text; Language)

We will have the following result:

The following values are used in this example:

• Text: A2 - cell with text for translation ("The quick brown fox jumps over the lazy dog").
• Language: B2 - translation language (French) ("French").

Example 2

The following values are used in this example:

• Text: A5:A15 - Range of cells with text for translation.
• Language: B1 - Translation language (Japanese) ("Japanese").

How Does It Work?

The AITRANSLATE() function can work both in normal mode and as an array function.

To use as an array, just enter the function in any cell, specifying the appropriate parameters. After that, you need to press Ctrl+Shift+Enter to enter the array formula, and LO Calc will automatically return a table with data.

To select all cells related to an array formula, simply select any cell in the array and press Ctrl+/.

If you need to convert an array formula to a value - select the entire array and in the Data > Calculate menu select Formula to Value.

Download Extension

You can use the function AITRANSLATE() by installing the YLC Utilities extension.

After that, this function will be available in all files opened in Excel (LibreOffice Calc).