duplicate
 

how do I go about finding if there are many words that come back up more than
once in the text? without using the find option. Let's say that I do not know
which word might come up more than once, and I want to discover which ones
do, how do I do that?

duplicate
 

If you're talking about a list of words then you could use Data, Filter,
Advanced Filter to get a list of the unique words. Then you could use the
Countif to determine how many there are of each.

If you're talking about analyzing paragraphs of text there is nothing built
into Excel to do this that I know of.

--
Jim
"amie etincelle" <amie wrote in message
...
| how do I go about finding if there are many words that come back up more
than
| once in the text? without using the find option. Let's say that I do not
know
| which word might come up more than once, and I want to discover which ones
| do, how do I do that?