=WORDSPLIT
The =WORDSPLIT() function accepts plain text and splits the text into a semicolon-separated list of words and optionally returns a specific word index from the list. (ProcessPlan uses semicolons as its list delimiter.)
Syntax
Section titled “Syntax”=WORDSPLIT(ReturnWordIndex; PlainText)Examples
Section titled “Examples”=WORDSPLIT(0; This is some plain text.)Returns: This;is;some;plain;text
The zero index returns the entire word list, now separated by semicolons.
=WORDSPLIT(3; This is some plain text.)Returns: some
Returns the single word in the third index location.
Note: Formula functions are case sensitive and must be in all caps.