How to Remove Duplicate Words in Excel

1. Open the worksheet.
2. Click the 'Home' tab on the command ribbon.
3. Click the 'Find Select' down arrow button in the 'Editing' group.
4. Click the 'Replace' command. A 'Find and Replace' dialog box will appear.
5. Click the 'Replace' tab. This tab includes two text boxes: 'Find what' and 'Replace with.'
6. Enter the word in the 'Find what' text box.
7. Leave a blank in the 'Replace with' box.
8. Click the 'Find All' button. A list of the repeated word(s) and cell references will appear.
9. Click on the row that contains the repeated word.
10. Click the 'Replace' button. The repeated word will disappear from that row. Click on other rows and the 'Replace' button to remove this word from other parts of the worksheet.