bootstrap templates

CTX Text

Simple Text Functions in Excel
She sells sea shells by the sea shore- 8 words in a list
Text To Array

List of words appearing in a text sample. Punctuation removed. Text To Array strips punctuation that is used as structure but preserves words like "1.2", "#cool", and "v_4_0".

she sells sea shells by the sea shore- 8 total words
Total Word Count

Integer output of the total word count. Words are counted using the same logic as Text To Array and Unique Words, so you can expect consistent output from the three.

she sells sea shells by the sea shore- 7 unique words
Unique Words

Similar to Text To Array, but lists only the unique words and the number of times that each word occurs. In the above example, the list is shorter by 1 term because "sea" appears twice.