Hey guys
I have a word document with emails. Can we sort this and delete duplicates in word? I appreciate the help you guys are amazing! I have a couple different files so if anyone has some way to do this it would be very helpful.
Hey guys
I have a word document with emails. Can we sort this and delete duplicates in word? I appreciate the help you guys are amazing! I have a couple different files so if anyone has some way to do this it would be very helpful.
There is no easy way to do this in Word. I suggest you Find & Replace ", " to "paragraph mark", and " " to "paragraph mark" (your data is kind of messy), then copy the data to Excel then use Data > Remove Duplicates, then copy back to Word.
The attached Word file is your original data with Find & Replace to get each email address on one line.
The attached Excel file is that list with duplicates removed.
Copying back to the Word file is left as an exercise to the student.
First off, thank you!
I am a little confused. I wanted to try this on another group of email addresses. I could delete all the commas, which made a lot of sense. However, how do I format the names so I can paste them into a single row in excel? That was a significant issue, and I do not understand how to do that.
I appreciate the help!
Maybe I don't understand what final result you want.
I suggest you Find & Replace ", " to "paragraph mark", and " " to "paragraph mark" (your data is kind of messy)
This will result in one email address per line in your Word file
then copy the data to Excel then use Data > Remove Duplicates, then copy back to Word.
This will result in one email address per row in one column in Excel
You do not want them in a single row in Excel. You can't do anything useful with that.
Do you need the final result in a single line in Word? If so you have to do another Find & Replace to change "paragraph mark" back to ", "
Yes, you can sort and remove duplicates in a Word document with emails. Here's how you can do it:
Open your Word document and select the emails you want to sort and remove duplicates from.
Click on the "Sort" button in the "Paragraph" section of the "Home" tab.
In the "Sort Text" dialog box, select "Paragraphs" in the "Sort by" dropdown menu and choose the sort order you prefer, such as ascending or descending.
Click "OK" to apply the sorting.
To remove duplicates, select the sorted emails and click on the "Remove Duplicates" button in the "Table Tools" tab.
In the "Remove Duplicates" dialog box, select the columns you want to remove duplicates from, such as "Email Address" or "Subject", and click "OK" to apply the removal.
Save your sorted and deduplicated document by clicking on "File" > "Save" or "File" > "Save As" if you want to create a new file.
You can repeat these steps for other Word documents with emails.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks