• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1562
  • Last Modified:

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:

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.

3 Solutions
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
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
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:
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.
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
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!


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now