Syntax
TRUNCATEWORDS(text, length, [ellipsis])
Examples
Input |
|
Formula |
|
Output |
|
An optional third argument controls the characters inserted if the text is truncated (instead of `...`):
Input |
|
Formula |
|
Output |
|
Setting the third argument to `""` prevents any text being inserted if the text is truncated:
Input |
|
Formula |
|
Output |
|