How do you delete repetitive words in excel?
- 1 Answers
- 804 Views
- I also Faced
- E-Mail Answers
Answer / Mandeep Singh
To remove duplicate values within a column, select the entire column, go to 'Data' tab, click on 'Remove Duplicates'. If you want to remove duplicate words within cells, use the 'Text to Columns', split by delimiter, and then delete duplicate rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a defined name in excel?
Can I use an if formula in conditional formatting?
What are the advantages of conditional formatting?
How do you merge cells using the keyboard?
How do you color code tabs in excel?
How do I format tabs in excel 2013?
What is the trim function?
What is the table formula in excel?
How do you insert five rows in a spreadsheet?
What is countif function in excel?
Is tableau better than excel?
How do I equal conditional formatting in excel?
MS Excel Microsoft 
