Find Duplicate Names and Words in Word 2007
Question details
Find repeated words in a Word document or duplicate names in a list.

- Product
- Microsoft Word 2007
- Device & OS
- not provided
- Scenario
- A user wants to check ordinary text for repeated words or clean up a list of names in a Word document.
- Observed behavior
- Word 2007 has no dedicated tool for finding every duplicate name in a list; the spelling checker may identify repeated words but is not reliable for duplicate names.
Decide whether you are checking repeated words in sentences or duplicate entries in a list. For a name list, make sure each name is on a separate line before copying it into a spreadsheet.
Remove duplicate names from a Word list using Excel
Use Excel's Remove Duplicates command when each name is a separate list entry.
In Word, select the names and press Ctrl+C.
Open a blank Excel worksheet, select cell A1, and press Ctrl+V. Check that each name appears in a separate cell in the same column.
Select the pasted column and choose Data > Remove Duplicates. Confirm whether the selection has a header, select the name column, and click OK.
Review the remaining names, copy the cleaned column, and paste it back into the Word document if needed.

Check for repeated words with Word's spelling checker
Use the spelling checker to catch some repeated words in ordinary text.
Clean up a Word name list with WPS Spreadsheet
Copy a list from WPS Writer into WPS Spreadsheet, remove duplicate entries, and paste the cleaned list back into your document.
- 1. Open and copy the list: Open the document in WPS Writer, select the names, and press Ctrl+C.
- 2. Paste into a spreadsheet: Open a blank WPS Spreadsheet, select cell A1, and press Ctrl+V. Verify that each name is in a separate cell.
- 3. Remove duplicate entries: Select the name column and choose Data > Duplicates > Remove Duplicates. Review the selected range and confirm the removal; menu labels may vary by version.
- 4. Paste the cleaned list back: Copy the remaining names from the spreadsheet and paste them into the document in WPS Writer.

Frequently Asked Questions
Can Word 2007 find every duplicate name in a document?
Word 2007 does not have a dedicated tool for finding every duplicate name in a list. Copy the list into Excel and use Data > Remove Duplicates to clean matching entries.
How do I check for a word typed twice in a row?
In Word 2007, press F7 or choose Review > Spelling & Grammar. The checker may flag repeated words so you can review and correct them.
Why did some duplicate names remain in Excel?
Entries with different spelling or extra spaces may not match. Inspect and standardize the names in the worksheet, then select the column and run Data > Remove Duplicates again.
Does Remove Duplicates highlight names before deleting them?
No. Excel's Data > Remove Duplicates command removes matching entries from the selected range. Review the list and selection before confirming.




