How To Find Duplicate Text & Delete In Excel?

To find the duplicate text in excel is simple. To sort duplicates text in excel follow the below steps:

1. Select the text you need to find duplicates in excel (A1:B19)

2. Click Home tab > Click “Conditional Formatting” > “Highlight Cells Rules” > “Duplicate Values”

3. Duplicate values format cells click “OK”

4. As a result, excel highlights the duplicate keywords 

How to delete duplicate text in excel?

1. Tab on the “Home” > select heading (keyword 1 & keyword 2) > click on the “Filter” options.

2. Click on Icon (keyword 1) > Select “Filter by color” and click on the color.

3. As a result, all duplicate text shows up 

4. Now, Select all duplicate text in excel and delete