How to excel in a row in order to remove duplication of data

For example:The result is:
San
San
Wang Li Li Wang five five five
Wang Li Li
Thank you
a bit, so I will be online Waiting for the

If you are using a Excel2007, click on the “data” – “Data Tools” – “to delete duplicate items” According to the prompts to enter = IF (COUNTIF (A2:$ A $ 2, A2) = 1 ,””,” repeat “), a repeat of the show will repeat the word, is not to repeat the air, and then sort OK, on the data – screening – screening of high-level
in the pop-up dialog box settings
attention accordingly, it is necessary to check the “opt-out to repeat the record”