Then use replace to remove the duplicates -
http://www.gmayor.com/replace_using_wildcards.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Daiya Mitchell wrote:
Which features in Excel would make this any easier?

You can use Table | Sort (even if the list is not a table) and it will
alphabetize the list, putting all the duplicates together.


On 6/2/05 1:52 PM, "Martin P" wrote:

Copy to Excel and use Excel's features.

"wendyp" wrote:

how do I find repeating words in a list. It would look like this

cat
dog
horse
goat
bird
cat
snake

I want a way to delete or find the second cat because it is
repeated.