GetWord function

GETWORD() Description

The GETWORD() function returns any word in the text based on a given set of delimiters.

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

Main Features of the GETWORD Function

Syntax:

=GETWORD(Text, Entry, [Delimiters])

Parameters:

• Text: Cell with text.
• Entry: The ordinal number of the occurrence of the required word. 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.
• [Delimiters]: Optional. One or more separators. By default, all symbols that are not part of a word are used (analog \W in regular expressions ).

Example Usage

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

=GETWORD(Text; Entry; Delimiters)

We will have the following result:

This example uses the following values:

• Text: A4 - The cell containing the text ("001_002.003-004:005/006@007") .
• Entry: D3 - Entry serial number (1) .
• Delimiters: B4 - Set of separators (if empty - default separators are used) ("") .

Alternative functions

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

Download extension

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

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