TOP

GetNumber function for Excel (Calc)

GETNUMBER() Description

The GETNUMBER() function is designed to retrieve numbers from text.


Main Features of the GETNUMBER Function

Syntax:

=GETNUMBER(Text; Entry)

Parameters:

Example Usage

The GETNUMBER() function is easy to use. You just need to enter any text with numbers and specify the ordinal number of the required number, and Excel (Calc) will automatically return the specified entry:

=GETNUMBER(Text; Entry)

We will have the following result:

GETNUMBER formula usage

This example uses the following values:

Download extension

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

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