token/type count?

[ciara]

Hi,
I'm not sure if it's possible to do this in excel (I know you can do i
with Perl, but that looks too complicated for me!) but I was wondering
is it possible to get Excel to count the tokens/types of words in
cell? So I have a paragraph, and I want a measure of how repetitive i
is - how many words there are, divided by how many different types o
words there are. If this isn't possible in excel, does anyone have an
idea how I should do it, besides complex programming things?
Thanks,
Ciar

 

[Frank Kabel]

Hi
a workaround: Copy your data to MS Word and use MS Word's statistical
features

 

[Myrna Larson]

The OP mentioned "different types of words". If he/she means "parts of
speech", Word can't count nouns, verbs, adjectives, adverbs, prepositions,
etc., can it?

 

[Frank Kabel]

Hi Myrna
AFAIK it can't (but could be wrong as I never use Word's statistical
features...)