Hello, we have a horizontal list of email addresses that were created in MS Word. They are separated by semi-colons and single spaces.
EXAMPLE: (firstname.lastname@example.org; email@example.com; firstname.lastname@example.org; Telephone2@verizon.com;)
The list is about five hundred addresses.
We would like to have them converted into a single list similar to to this:
1. The semi-colons may or may not be included in the list.
2. The list should be put into a single column, MS Word table, Text file, or Excel spreadsheet (single column).
3. The addresses now have the normal blue line under each address which makes them "hot". These lines may be removed or left in place.
We are using a PC using MS Word and Excel version 10.
Once they are placed into a single list, we will place them in alphabetical order and eliminate any duplicates. If this can be done easily, that would be good; if not, we can make those changes.
Any assistance will be appreciated.