LeftWords

Returns text containing the specified 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 version 

6.0 or earlier

Example 1 

LeftWords ( "Plaid Canvas Suitcase" ; 2 ) returns Plaid Canvas.

Example 2 

LeftWords ( Name ; 1 ) returns Sophie, when the Name field contains Sophie Tang.