Hi, Lili. I do lots and lots of cleaning up and converting of data. I'm
fairly good with both Word and Excel, so I tend to copy and paste back and
forth a lot. If this were me, I'd be trying to convert this to a Word table
(if it's not already) and then you can paste right into Excel. Removing
dupes in Excel is much more simple. See:
http://www.officearticles.com/excel/...ft_excel. htm
Before you convert to a table, you'll want to make sure that each individual
"record" has a paragraph return at the end (not a line break).
************
Anne Troy
www.OfficeArticles.com

"Lili Vivanco" Lili wrote in message
...
We printed all the records in our database for QA/QC before dumping them
into a
new database.
I used Word to remove extra line breaks and that worked very well. But I
noticed that some text lines (of the title field) are duplicated in some
records-- the consequence of a previous conversion.
Is there a way I can use Word (macro, find & replace of
formatting--what??)
to remove the dupicate text lines? There are almost 8,000 pages of
printed
records and I would hate to have to find them and change them one by one.
If Word cannot do that, does anyone know what else might work?
Thank you for anything at all. Even a no will save me from hours of
reading
help columns.

Anne,
Thank you so much-- I will convert to a table and also try what the other
user suggested and see which works fastest :^) It will be a learning
experience either way.
Thanks so much.

"Anne Troy" wrote:

Hi, Lili. I do lots and lots of cleaning up and converting of data. I'm
fairly good with both Word and Excel, so I tend to copy and paste back and
forth a lot. If this were me, I'd be trying to convert this to a Word table
(if it's not already) and then you can paste right into Excel. Removing
dupes in Excel is much more simple. See:
http://www.officearticles.com/excel/...ft_excel. htm
Before you convert to a table, you'll want to make sure that each individual
"record" has a paragraph return at the end (not a line break).
************
Anne Troy
www.OfficeArticles.com

"Lili Vivanco" Lili wrote in message
...
We printed all the records in our database for QA/QC before dumping them
into a
new database.
I used Word to remove extra line breaks and that worked very well. But I
noticed that some text lines (of the title field) are duplicated in some
records-- the consequence of a previous conversion.
Is there a way I can use Word (macro, find & replace of
formatting--what??)
to remove the dupicate text lines? There are almost 8,000 pages of
printed
records and I would hate to have to find them and change them one by one.
If Word cannot do that, does anyone know what else might work?
Thank you for anything at all. Even a no will save me from hours of
reading
help columns.

Lili: Steve's macro should work far faster, of course, but sometimes it
takes longer to implement the macro. Tough to say.
************
Anne Troy
www.OfficeArticles.com

"Lili Vivanco" wrote in message
...
Anne,
Thank you so much-- I will convert to a table and also try what the other
user suggested and see which works fastest :^) It will be a learning
experience either way.
Thanks so much.

"Anne Troy" wrote:

Hi, Lili. I do lots and lots of cleaning up and converting of data. I'm
fairly good with both Word and Excel, so I tend to copy and paste back
and
forth a lot. If this were me, I'd be trying to convert this to a Word
table
(if it's not already) and then you can paste right into Excel. Removing
dupes in Excel is much more simple. See:
http://www.officearticles.com/excel/...ft_excel. htm
Before you convert to a table, you'll want to make sure that each
individual
"record" has a paragraph return at the end (not a line break).
************
Anne Troy
www.OfficeArticles.com

"Lili Vivanco" Lili wrote in message
...
We printed all the records in our database for QA/QC before dumping
them
into a
new database.
I used Word to remove extra line breaks and that worked very well. But
I
noticed that some text lines (of the title field) are duplicated in
some
records-- the consequence of a previous conversion.
Is there a way I can use Word (macro, find & replace of
formatting--what??)
to remove the dupicate text lines? There are almost 8,000 pages of
printed
records and I would hate to have to find them and change them one by
one.
If Word cannot do that, does anyone know what else might work?
Thank you for anything at all. Even a no will save me from hours of
reading
help columns.

Steve?

"Anne Troy" wrote in message
...
Lili: Steve's macro should work far faster, of course, but sometimes it
takes longer to implement the macro. Tough to say.
************
Anne Troy
www.OfficeArticles.com

"Lili Vivanco" wrote in message
...
Anne,
Thank you so much-- I will convert to a table and also try what the
other
user suggested and see which works fastest :^) It will be a learning
experience either way.
Thanks so much.

"Anne Troy" wrote:

Hi, Lili. I do lots and lots of cleaning up and converting of data. I'm
fairly good with both Word and Excel, so I tend to copy and paste back
and
forth a lot. If this were me, I'd be trying to convert this to a Word
table
(if it's not already) and then you can paste right into Excel. Removing
dupes in Excel is much more simple. See:

http://www.officearticles.com/excel/...ft_excel. htm
Before you convert to a table, you'll want to make sure that each
individual
"record" has a paragraph return at the end (not a line break).
************
Anne Troy
www.OfficeArticles.com

"Lili Vivanco" Lili wrote in
message
...
We printed all the records in our database for QA/QC before dumping
them
into a
new database.
I used Word to remove extra line breaks and that worked very well.
But
I
noticed that some text lines (of the title field) are duplicated in
some
records-- the consequence of a previous conversion.
Is there a way I can use Word (macro, find & replace of
formatting--what??)
to remove the dupicate text lines? There are almost 8,000 pages of
printed
records and I would hate to have to find them and change them one by
one.
If Word cannot do that, does anyone know what else might work?
Thank you for anything at all. Even a no will save me from hours of
reading
help columns.