I have about a 1000 names arranged in column A. My problem is however, each name appears twice, for example:

Cell 1 = Adam SparksAdam Sparks
Cell 2 = Ging FreecssGing Freecss
Cell 3 = Steve PetersonSteve Peterson
and so on

I want the name to appear just once. Please help.