Function AiExtract

AIEXTRACT() Description

The AIEXTRACT() function is designed to retrieve data from cells using AI directly in the worksheet of Excel (Calc).

To retrieve data from cells, this function uses Google's Gemini large language model and can be used in any formulas, either independently or in conjunction with other standard functions.

Main Characteristics of the AIEXTRACT Function

Syntax:

=AIEXTRACT(Prompt; Context)

Parameters:

• Prompt: Text containing instructions for data retrieval.
• Context: References to cells containing text with data.

Example Usage

Suppose you need to extract specific data from each cell. You only need to enter the AIEXTRACT() formula and specify the prompt with instructions, and Excel (Calc) will automatically extract the data using AI:

=AIEXTRACT(Prompt; {Context})

We will have the following result:

The following values are used in this example:

• Prompt: B1 - Cell with text for the prompt ("Phone numbers").
• Context: B5:B14 - Range with cells containing data ({Context}).

How Does It Work?

Simply enter the AIEXTRACT() function in any cell, specifying the prompt text and the range of cells from which you want to retrieve data. After that, press Ctrl+Shift+Enter to enter the array formula, and Excel (Calc) will automatically extract the data.

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

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

Download the extension

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

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