sherman6789
asked on
We need to convert a horizontal list of email addresses into a single vertical list
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: (abc@zyz.com; ghjk.xxx@qwe.com; ws@gogo.com; 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:
abc@zyz.com;
ghjk.xxx@qwe.com;
ws@gogo.com;
Telephone2@verizon.com;
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.
Thank you.
sherman6789
EXAMPLE: (abc@zyz.com; ghjk.xxx@qwe.com; ws@gogo.com; 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:
abc@zyz.com;
ghjk.xxx@qwe.com;
ws@gogo.com;
Telephone2@verizon.com;
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.
Thank you.
sherman6789
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> Pal Sauve=200 points, Graham Skan=150 points, Thinkpads_User=50 points.
William - a little mix-up in the points! But don't worry about it - it all works out in the wash!
William - a little mix-up in the points! But don't worry about it - it all works out in the wash!
ASKER
Pal Sauve=200 points, Graham Skan=150 points, Thinkpads_User=50 points.
Thank you.
-William Sherman