In an adjacent column, add this formula

=If(COUNTIF($A$1:A1,A1)1,"Dup","")

and copy down

Then filter column B and select a value of Dup. Delete all visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"naminel" wrote in message
...
I am using Office XP and I was wondering how to delete duplicates. Is
there
a procedure in Excel where I can do this in one key stroke? My list
consists
of 14,000 lines, so as you can see it would be quite cumbersome to go
through
manually to delete them. Any help would be greatly appreciated.