GetWord Function

GETWORD() Description

The GETWORD() function extracts the required word from a text string by the specified sequence number and set of delimiters. A convenient tool for quick parsing and cleaning of raw data.

You can also use the ready-made tool Get word by delimiters.

Key Features of the GETWORD Function

Syntax:

=GETWORD(Text, Entry, [Delimiters])

Parameters:

• Text: A cell with text.
• Entry: The sequence number of the required word occurrence. It can also have a negative value, which means searching for the occurrence from the end of the string. With a value of 0, it returns all occurrences.
• [Delimiters]: Optional. One or more delimiters. By default, all characters that are not part of a word are used (analog of \W in regular expressions).

Usage Example

The GETWORD() function is easy to use. You only need to specify the cell with the text and Excel (Calc) will automatically return the required word:

=GETWORD(Text; Entry; Delimiters)

We will get the following result:

The following values are used in this example:

• Text: A4 - Cell containing the text ("001_002.003-004:005/006@007").
• Entry: D3 - Sequence number of the occurrence (1).
• Delimiters: B4 - A set of delimiters (if empty - default delimiters are used) ("").

Alternative functions

You can also use the GETSUBSTR() function, which is very similar, but can split text only by one specified delimiter.

Download Extension

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

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