People need a help with my problem ..
I'm working on a xml in excel which has more than 200,000 rows, 4 columns, these rows have text in English and Chinese Simplified together and apart.
what I need is to delete all the rows that have Chinese texts only column C (replacement).
I hope you can help me .. they are grateful from the heart
I upload my work
Hello sfgabriel,
Bienvenido al foro!
Welcome to the Forum!
The macro below will test each cell in column "D" to be sure the cell contains only English characters. If not then the row that cell is on will be deleted.
The macro has been added to the attached workbook. You can run the macro from the macro dialog box by pressing ALT+F8 and Double Clicking on DeleteChineseRows.
Module1 - Macro Code
Please Login or Register to view this content.
Last edited by Leith Ross; 04-27-2015 at 08:20 PM.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Column D ?Originally Posted by sfgabriel
try
Please Login or Register to view this content.
thank you very much for your macro is super great, it's what I needed ... until now what I wanted to meet again many thanks Leith Ross and jindon..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks