Function GetSubStr

GETSUBSTR() Description

The GETSUBSTR() function is designed to get a part of the text by a given delimiter.

Main Characteristics of the GETSUBSTR Function

Syntax:

=GETSUBSTR(Text; Delimiter; Entry)

Parameters:

• Text: The text to be split into parts.
• Delimiter: Any character or set of characters to be used as a text delimiter.
• Entry: The ordinal number of the text part (occurrence). It can also have a negative value, which means searching for an occurrence from the end of the string. If the value is 0, it returns all occurrences.

Example of Use

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

=GETSUBSTR(Text; Delimiter; Entry)

We will get the following result:

In this example, the following values are used:

• Text: A3 - The text to be split into parts ("apple-banana-mint").
• Delimiter: B3 - Text delimiter ("-").
• Entry: C3 - Ordinal number of the text part (1).

Download extension

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

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