TOP

GetSubStr function for LibreOffice Calc

YLC Utilities logo

GETSUBSTR() Description

The function GETSUBSTR() is designed to receive part of the text by the given separator.


Main Features Functions GETSUBSTR

Syntax:

=GETSUBSTR(Text; Delimiter; Entry)

Parameters:

Example Usage

The GETSUBSTR() function is easy to use. You just need to enter any text, specify the delimiter and the sequence number of the required part of the text, and LibreOffice Calc will automatically split the string of characters into parts and return the specified piece of text:

=GETSUBSTR("apple-banana-mint"; "-"; 1)

We will have the following result:

GETSUBSTR formula usage

This example uses the following values:

Extension "YouLibreCalc.oxt"

You can use the function GETSUBSTR() by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.