How to Remove Duplicate Words in Excel


Microsoft Excel 2010 can remove duplicate words from a worksheet. Excel's editing commands include a "Find & Select" button on the command ribbon. Excel will find all the duplicate words in the worksheet and replace them with a blank or other text.

  • Open the worksheet.

  • Click the "Home" tab on the command ribbon.

  • Click the "Find & Select" down arrow button in the "Editing" group.

  • Click the "Replace" command. A "Find and Replace" dialog box will appear.

  • Click the "Replace" tab. This tab includes two text boxes: "Find what" and "Replace with."

  • Enter the word in the "Find what" text box.

  • Leave a blank in the "Replace with" box.

  • Click the "Find All" button. A list of the repeated word(s) and cell references will appear.

  • Click on the row that contains the repeated word.

  • 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.

Tips & Warnings

  • To replace the duplicate word with other text, enter the new text in the "Replace with" box.


Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!