PULSE.WORDCOUNT

PULSE.WORDCOUNT is a custom Excel function provided by the Pulse for Excel add-in. It counts the number of words within a given text string or cell reference.

Syntax

=PULSE.WORDCOUNT(text)

Parameters

  • text (string | cell reference) — The text or the cell containing the text for which you want to count the words.

Return Value

Returns an integer representing the number of words in the provided text. If the input is empty or contains only whitespace, the result is 0.

Examples

Example 1: Direct text input

=PULSE.WORDCOUNT("Hello world from Pulse") // Returns: 4

Example 2: Cell reference

// If A1 contains "Count these words" =PULSE.WORDCOUNT(A1) // Returns: 3

Remarks

  • Punctuation is not counted as words. Words are delimited by spaces, tabs, or line breaks.
  • Multiple consecutive whitespace characters are treated as a single separator.
  • Empty strings or cells with no text return 0.

See Also