Hello,
Do you mean you cannot get it done with the feature of the Kutools for Excel?
Please try to create some sample data in a new workbook and try it again.
If the problem persists with the sample workbook, please attach it here or send to jaychivo@extendoffice.com with detailed information.
BTW, you should post the topic in the Official section.
Thanks in advance.

Hi
I had a quick go and trying to replicate the problem in a small test spreadsheet. If I copy a few affected cells into the test spreadsheet and try KUTools (kutools->Text->remove characters) it works (Character is ' ).
However.. if I copy the whole affected column into the test spreadsheet then it does not work. The column has about 13,000 rows in it and some of the fields I am trying to clean have a few hundred characters in them so I am dealing with a large data set.
Are there any debug logs produced by kutools that I could look at to see if there is any indication as to what is going wrong?