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

--
ciar
-----------------------------------------------------------------------
ciara's Profile: http://www.excelforum.com/member.php...nfo&userid=317
View this thread: http://www.excelforum.com/showthread.php?threadid=26429

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

--
Regards
Frank Kabel
Frankfurt, Germany

"ciara" schrieb im Newsbeitrag
...

Hi,
I'm not sure if it's possible to do this in excel (I know you can do
it
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 a
cell? So I have a paragraph, and I want a measure of how repetitive
it
is - how many words there are, divided by how many different types of
words there are. If this isn't possible in excel, does anyone have
any
idea how I should do it, besides complex programming things?
Thanks,
Ciara


--
ciara
---------------------------------------------------------------------
---
ciara's Profile:
http://www.excelforum.com/member.php...fo&userid=3179
View this thread:
http://www.excelforum.com/showthread...hreadid=264290

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?

On Tue, 28 Sep 2004 19:56:11 +0200, "Frank Kabel"
wrote:

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Myrna Larson" schrieb im
Newsbeitrag ...
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?

On Tue, 28 Sep 2004 19:56:11 +0200, "Frank Kabel"

wrote:

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