Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The WORD function is used to extract a specific number of words from text. It is particularly useful for summarizing or truncating text to a certain length.
Syntax
WORD(text, [num_words])
The WORD function syntax has the following arguments:
- text: Required. The text string from which you want to extract words.
- num_words: Optional. The number of words to extract from the beginning of the text. If omitted, it defaults to 1.
Example
| Formula | Description | Result |
| =WORD("Hello world, this is a test", 3) | Extracts the first 3 words from the text. | Hello world, this |
Errors
For a full list of formula errors, please read Formula errors.