Reference > Functions reference > Text functions > WordCount


Returns a count of the total number of words in specified text.




text - any text expression or text field

Data type returned 


Originated in 

FileMaker Pro 6.0 or earlier


In addition to space, tab, enter, and carriage return characters, characters such as equal (=), ampersand (&), hyphen (-), and so on identify the beginning of a new word. For more information about word separators, search the FileMaker Knowledge Base.

Example 1 

WordCount ( "The sun is rising." ) returns 4.

Example 2 

WordCount ( Letter ) returns the total number of words in the Letter field. If the Letter field contains the text x=y=1.5, this example returns 3 because each equal (=) character identifies 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