Entry: Ordinal number of the required word occurrence. It can also have a negative value, which means searching for occurrences from the end of the string. With a value of 0 - returns all occurrences.
[Delimiters]: Optional. One or more delimiters. By default, all characters that are not part of a word are used (analogous to \W in regular expressions).
Example Usage
The GETWORD() function is easy to use. You just need to specify the cell with the text and Excel (Calc) will automatically return the required word:
=GETWORD(Text; Entry; Delimiters)
We will have 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 - Ordinal number of the occurrence (1).
Delimiters:B4 - Set of delimiters (if empty - default delimiters are used) ("").
Alternative functions
You can also use the function GETSUBSTR(), which is very similar, but can split text only by a single specified delimiter.
