How to Clear the Unwated Characters from a column?

Have you tried with Excel Application scope and followed by Write Range

Check out this thread

Regards
Gokul