How to remove URLS entries in Excel 2007??

[Makhdoom]

Hello Sir,

I am facing a problem. I want to find and remove duplicate entries in excel 2007. My work is Ad posting and i entered the duplicate URLs entries in my worksheet. How is it possible that i find and remove URLs entries?
The example of entries is here....
<table width="535" border="0" cellpadding="0" cellspacing="0" height="461"><col style="width: 245pt;" width="327"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 245pt;" width="327" height="17">http://011.co.uk/ShowAd.aspx?id=2001</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">http://www.123classifieds.us/category/235/Jobs/listings/5210/%28slvr-660412%29UKs-leading-Telemarketing.html</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">http://www.124.in/18115-slvr660412uks-leading-telemarketing/details.html</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">http://168.215.196.53/Mumbai-jobs-internet-company-%28slvr-660412%29UK%27s-leading-Telemarketing-adcontentid=632231</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">http://247freeads.co.uk/ShowAd.aspx?id=2559</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">http://1stopfreeads.com/slvr-660412uks-leading-telemarketing</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">http://www.24classifieds.co.uk/8999-slvr660412uks-leading-telemarketing.html</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">http://www.26thjanuary.co.uk/slvr-660412uks-leading-telemarketing
<table width="503" border="0" cellpadding="0" cellspacing="0" height="292"><col style="width: 200pt;" width="267"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 200pt;" width="267" height="17">011.co.uk/ShowAd.aspx?id=1864</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1000sads.com/irl-en/s16870_dimd-880052_great_opprotunity_for_success.html</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">123classifieds.us/index.php?a=2&b=4423</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">123indiaclassified.com/classified.php?choice=my</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">124.in/16284-dimd880052-great-opprotunity-for-success/details.html</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">168.215.196.53/-business-opportunity-franchises--%28dimd-880052%29---Great---Opprotunity---For---Success-!-adcontentid=628642</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1800-homes-for-sale.com/us/?db=us_homes_offices&website=hfs&language=&session_key=dab85750f77432a42717905e608bb06d&search_and_display_db_button=on&results_format=long&query=retrieval&db_id=1873903</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1smartlist.com/235/posts/15-Jobs/91-Accounting-Finance-Banking/29657--dimd-880052-Great-Opprotunity-For-Success-.html</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">1stopfreeads.com/dimd-880052-great-opprotunity-for-success</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">247freeads.co.uk/ShowAd.aspx?id=2211</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">24classifieds.co.uk/8548-dimd880052-great-opprotunity-for-success.html


Here are some duplicate links.
Now tell me how i remove it in excel?

</td> </tr> </tbody></table>

</td> </tr> </tbody></table>

 

[Robert Mika]

Which of the entries do you count as duplicates?
So far the are two indentical lines