[[email protected]]

I have about 5000 labels for a mailer I am putting together. I recieved them
in Word format. I believe that their are many duplicates. I would like to
sort them so that I can remove them prior to using them. Pasting them into
excel doesnt seem to work because it puts each line into a new cell and
sorting them jumbles the info. Is there any hope for me? Please help.

[Doug Robbins - Word MVP]

It is not clear exactly what you are starting with, but I suspect that it is
with a document in which the data for each label appears as you would have
it on the label itself. If that is correct, see "Convert Labels into Mail
Merge Data File" on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/convert_labels...mail_merge.htm

That will then get the labels into a format where you can sort them. Then
if you see the article "Finding and replacing characters using wildcards"
at:

http://www.word.mvps.org/FAQs/Genera...gWildcards.htm

you will find a method of removing the duplicates.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"
.com wrote in message
...
I have about 5000 labels for a mailer I am putting together. I recieved
them
in Word format. I believe that their are many duplicates. I would like
to
sort them so that I can remove them prior to using them. Pasting them
into
excel doesnt seem to work because it puts each line into a new cell and
sorting them jumbles the info. Is there any hope for me? Please help.

[[email protected]]

Thank you very much for your help. I followed your instruction and learned a
new trick - There were about 850 duplicates.

Thanks again,

Nick

"Doug Robbins - Word MVP" wrote:

It is not clear exactly what you are starting with, but I suspect that it is
with a document in which the data for each label appears as you would have
it on the label itself. If that is correct, see "Convert Labels into Mail
Merge Data File" on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/convert_labels...mail_merge.htm

That will then get the labels into a format where you can sort them. Then
if you see the article "Finding and replacing characters using wildcards"
at:

http://www.word.mvps.org/FAQs/Genera...gWildcards.htm

you will find a method of removing the duplicates.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"
.com wrote in message
...
I have about 5000 labels for a mailer I am putting together. I recieved
them
in Word format. I believe that their are many duplicates. I would like
to
sort them so that I can remove them prior to using them. Pasting them
into
excel doesnt seem to work because it puts each line into a new cell and
sorting them jumbles the info. Is there any hope for me? Please help.