LeftWords
Purpose 
Returns a text result containing numberOfWords in text, counting from the left.
Format 
LeftWords(text;numberOfWords)
Parameters 
text - any text expression or text field
numberOfWords - any numeric expression or field containing a number
Data type returned 
text
Examples 
LeftWords(“Plaid Canvas Suitcase”;2) returns Plaid Canvas.
LeftWords(Name;1) returns Sophie, when the Name field contains Sophie Tang.
Note  The ampersand (&) and hyphen (-) characters identify the beginning of a new word.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.