To Format Text In Excel Sheet

I need to format the text in a excel.

I have attached a excel in this post. in that excel sheet, i need to take the input from the first sheet. The input contains special characters like : , ; , " .

I want to do the following operations.

1. replace all the special characters with line break

2. some email addresses prefix with To: . I need to remove "To:", "cc:", "1st support contact:"

3. after doing these operations , need to trim the column to remove unnecessary blank spaces.

4. remove the duplicates in the column

5. Sort them.

6. Need to remove some email addresses from the list. eg: "ocgsoy, Ggo", "IRFO"

7.Sort them