Duplicate Rows

I have exported an Act 6.0 contact database into a .csv excel spreadsheet. It
worked perfect! Each contact occupies a single row. However, some of the
contacts are duplicates (existing before the export). Is there an easy way
that I can remove duplicated rows in a spreadsheet? I know there must be, but
how?
Thanks

"instauratio" <instauratio@discussions.microsoft.com> wrote in message
news:2483416E-4698-4BBF-A554-89DFAFA3AAD6@microsoft.com...
> I have exported an Act 6.0 contact database into a .csv excel spreadsheet.
It
> worked perfect! Each contact occupies a single row. However, some of the
> contacts are duplicates (existing before the export). Is there an easy way
> that I can remove duplicated rows in a spreadsheet? I know there must be,
but
> how?
> Thanks

Have a look at http://www.cpearson.com/excel/duplicat.htm