Home > Reference > Functions reference > Text functions > LeftWords
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 Originated in FileMaker Pro 6.0 or earlier Examples LeftWords(“Plaid Canvas Suitcase”;2) returns Plaid Canvas. LeftWords(Name;1) returns Sophie, when the Name field contains Sophie Tang. Note Characters such as the ampersand (&) and hyphen (-) can be used to 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