Removal of special characters and deduplication from a single column (accounting)

[CLEChemE]

Hello - I am working with an accounting spreadsheet with more than 350,000 lines and I need to do two things: 1) Replacement of special characters (i.e. $,%,*,', etc.) with a space (" "), 2) I need to indicate duplicates by removing them altogether from the listing and highlighting the cell yellow - however, the first value of the series (1,2,3,4...n) is to remain and be highlighted in green.

See the example of what I am aiming for below:

Original Data:

123A
123
123
124&
124%
125
126^
1#27
127

Corrected Data (via UDF?):

123 (highlighted in green)
(blank row in yellow)
(blank row in yellow)
124 (highlighted in green)
(blank row in yellow)
125
126
127(highlighted in green)
(blank row in yellow)

Thanks in advance for the help!!!