GetSubStr function for Excel

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:

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

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 Excel will automatically split the string of characters into parts and return the specified piece of text:

=GETSUBSTR(Text; Delimiter; Entry)

We will have the following result:

This example uses the following values:

• Text: A3 - Text, which must be broken into parts ("apple-banana-mint") .
• Delimiter: B3 - Text separator ("-") .
• Entry: C3 - Serial number of the text part (1) .

Download the extension

You can use the GETSUBSTR() function by installing the free extension YouLibreCalc.xlam .

After that, this function will be available in all files that will be opened in Excel.