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
sherman6789Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
If you can import into Excel (csv or otherwise) as columns - each email in a cell, then you can transpose the columns to rows. That is how I would do this.

... Thinkpads_User
0
GrahamSkanRetiredCommented:
You can do this in Word with a  single Find and Replace operation
Find: ;
Replace: ;'^p

this will keep the semi-colon but
Find: ;
Replace: ^p

will drop it
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Paul SauvéRetiredCommented:
I would suggest using Word!

Once you have done the find/replace operation (I would 'Find' '; ' (semi-colon+space) and 'Replace' with '^p' (control+p).

Select all the lines then select Insert table.

Select the column, click the Table tools - Layout tab - use the Sort option.

The resulting table will be in alphabetical order:
abc@zyz.com
ghjk.xxx@qwe.com
Telephone2@verizon.com;
ws@gogo.com
You will easily find the duplicates now - just delete the repeated rows.

Now you can copy the table into an Excel document and use it accordingly! Each Word table row will be copied into a separate cell in Excel.
0
sherman6789Author Commented:
Thanks to Thinkpads_User, Graham Skan and Paul Sauve.  The suggestion from Graham is the one that we will use immediately since it will be be the quickest and most useful for this particular project.  The suggestion from Thinkpads_User will be better for use on some other projects that we have since some of them need the results to be in Excel.  The suggestion from Paul is what we were going to use anyway in MS Word and have used it in the past. The 400 points will be divided for all three Experts; because, their suggestions will not only help us but may be useful to other users who study Experts-Exchange.  
Pal Sauve=200 points, Graham Skan=150 points, Thinkpads_User=50 points.

Thank you.

-William Sherman
0
Paul SauvéRetiredCommented:
>> 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!

;-)

PaulS
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.