Monday, May 07, 2007

How to Extract Addresses From a List

Sometimes you get an endless list that is composed of addresses, phone numbers, Fax numbers, email addresses. You want to extract only the web addresses from the list that looks like this:

The Marilyn and Marvin Simon JCC
5000 Corporate Woods Dr
Ste 100
Virginia Beach, VA 23462
757-489-1371
Fax 757-489-4427
Established 1952
www.simonfamilyj.org
- 37 -
Jewish Community Center
Richmond
Weinstein JCC
5403 Monument Ave
Richmond, VA 23226
804-288-6091
Fax 804-285-3139
Established 1952
www.richmondjcc.org

All you have to do is to
1. Copy the whole list to Microsoft Word
2. Select all
3. Go to Tables- Sort [a-z] – click it
4. The list will be sorted from A to Z and your addresses will be in one group under the letter W
Like this
- 37 -
5000 Corporate Woods Dr
5403 Monument Ave
757-489-1371
804-288-6091
Established 1952
Established 1952
Fax 757-489-4427
Fax 804-285-3139
Jewish Community Center
Richmond
Richmond, VA 23226
Ste 100
The Marilyn and Marvin Simon JCC
Virginia Beach, VA 23462
Weinstein JCC
www.richmondjcc.org
www.simonfamilyj.org

5. Erase superfluous lines

3 comments:

Anonymous said...

Aren't those web site addresses and not email addresses? Well, not a question really, because those are site urls, they are not email addresses.

zeevveez said...

Thanks for the comment- I fixed it. Hope the idea is clearer now.

Anonymous said...

yea ..Thanks for the clarification then..
best regard