How to Remove Duplicate Email-ids in Notepad or MS-Word or MS-Excel file.

If you have a bunch of email ids in a notepad file which may contain duplicate email ids and you want only unique mail ids. So at this time this tutorial will be helpful to you to remove duplicate email ids in notepad or MS-Word or MS-Excel file easily.

While working with large number of email ids, there is a chance that the email ids may contain duplicate email ids like repeated email ids. In short you can delete them manually by go through each and every one. But while in large number of email ids like 10,000 or 50,000, it is impossible to find the duplicates and impossible to remove them manually. So for doing this removal process easy we have a small and very simple trick in MS-Excel.

If you want to send an invitation or any other newsletter to your friends or students or customers and you have all of their email ids, but you have duplicates in those email ids. So you need to manually select the duplicates and you have to remove them. This work takes long time. So you need to make it faster with 2 or 3 clicks. So many online services or available to do this work but you can complete this work with 2-3 clicks. So why you need to go for online. Just follow the steps below and remove duplicate email ids on your notepad files or MS-Word or MS-Excel file very easily.

How to Remove Duplicate Email Ids is Notepad/MS-Word/MS-Excel :

In Notepad :

Step 1 : Open your notepad file which contains email ids.

Step 2 : Select all email ids by clicking “ctrl+A” and then copy by pressing “ctrl+c”.

Step 3 : Now Open a new MS-Excel file and Paste all email ids in that excel file.

Step 4 : Make sure that all email ids are placed in each cell in Ms-Excel. By default all the email ids are placed as well.

Step 5 : Now Select all email Ids in Excel file and open “Data” menu.

Step 6 : In Data menu select “remove duplicates”.

Step 7: A popup will open and shows the column name which contains email ids. (Formally “Column A”). and check that column in that popup window.

Step 8 : After selecting that check box click “OK” and then wait for a second. Now a message will appear says that number of duplicate email ids and removed.

In this way you can simply remove duplicate email ids in a large number of emails in notepad file.

In Excel :

Step 1 : Open MS-Excel file which contains email ids.

Step 2 : Select the entire row of email ids.

Step 3 : Go to “Data” menu in menu bar and select “remove duplicates” option.

Step 4 : Now a popup window will appear and shows the column name which contains email ids.

Step 5 : Select the column and click on “OK”.

Step 6 : After completing the removal process a message box will appear and says that the number of duplicate emails found and removed.

In this way you can simply remove duplicate email ids in a large number of emails in MS-Excel file.

In MS-Word :

Step 1 : Open your MS-Word file which contains email ids.

Step 2 : Select all email ids by pressing“ctrl+A” and then copy by pressing “ctrl+c”.

Step 3 : Now Open a new MS-Excel file and Paste all email ids in that excel file.

Step 4 : Make sure that all email ids are placed in each cell in Ms-Excel. By default all the email ids are placed as well.

Step 5 : Now Select all email Ids in Excel file and open “Data” menu.

Step 6 : In Data menu select “remove duplicates”.

Step 7 : A popup will open and shows the column name which contains email ids. (Formally “Column A”). and check that column in that popup window.

Step 8 : After selecting that check box click “OK” and then wait for a second. Now a message will appear says that number of duplicate email ids and removed.

In this way you can simply remove duplicate email ids in a large number of emails in MS-Word file.