word - a quick request

[Guest]

Hi,

I have a word document that I need help with. I am doing research work on a
history book. The doc. is essentially a list of names and years.

It looks like this:

1967

johnson
anderson


orion, falkner, wang, chang, wing, wong



The first name under the year is the chairman, the second is the vice
chairman. The names under this are the other board members for that year.
What I need to do is to simply alphabatize all of the names and remove
duplicates. I know this must be simple enough for someone who has more
extensive knowledge with this program; but for me it has been a nightmare. I
would be so grateful for detailed help.

Thank you so much



Here is the file
http://www.filelodge.com/files/room47/1375314/nipawinnames.doc

 

[Graham Mayor]

If the text is repetitive with the same format, it should be possible to
convert it into a table - see if
http://www.gmayor.com/convert_labels_into_mail_merge.htm helps. If the
table is sorted then it is a relatively simple matter to remove duplicates
from the sorted column using replace - see the examples at
http://www.gmayor.com/replace_using_wildcards.htm

Whatever your linked document is, it certainly isn't a Word document - but
an HTML file with quite a lot of stuff in there that I wouldn't want running
on my PC. Treat the link with great suspicion!!


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Suzanne S. Barnhill]

If I understand you correctly and you just want an alphabetical list of all
the people who have served in any capacity in any year (that is, you're not
trying to keep the officers from a single year together), then here's the
plan:

1. Use Find and Replace to find ", " (that's a comma and a space, without
the quotation marks) and replace with ^p (a paragraph mark). This will put
every name in a separate paragraph (assuming there's not a line break after
the chairman's name).

2. Select all the text and use Table | Sort, by paragraphs, to sort the
entire list. Any empty paragraphs will sort to the top, followed by the
dates. These can be deleted, and what remains will be an alphabetical list.
You'll need to remove duplicates by hand or by following directions in the
link Graham gave you.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

thank you very much!

If I understand you correctly and you just want an alphabetical list of all
the people who have served in any capacity in any year (that is, you're not
trying to keep the officers from a single year together), then here's the
plan:

1. Use Find and Replace to find ", " (that's a comma and a space, without
the quotation marks) and replace with ^p (a paragraph mark). This will put
every name in a separate paragraph (assuming there's not a line break after
the chairman's name).

2. Select all the text and use Table | Sort, by paragraphs, to sort the
entire list. Any empty paragraphs will sort to the top, followed by the
dates. These can be deleted, and what remains will be an alphabetical list.
You'll need to remove duplicates by hand or by following directions in the
link Graham gave you.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.