0
Undo
Votes
Hi
I am trying to remove apostrophes that are in random locations in large text cells. I have tried using Text->Remove Characters and Text->Replace Accented Characters by configuring both tools to remove of replace apostrophes . However they do remove or replace apostrophes in the text cells that I am selecting.
How do I do this with KUTools ?
Thanks
Rob
I am trying to remove apostrophes that are in random locations in large text cells. I have tried using Text->Remove Characters and Text->Replace Accented Characters by configuring both tools to remove of replace apostrophes . However they do remove or replace apostrophes in the text cells that I am selecting.
How do I do this with KUTools ?
Thanks
Rob
0
Undo
Votes
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.
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.
0
Undo
Votes
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?
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?
- Page :
- 1
There are no replies made for this post yet.
Copyright © 2009 -
www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
