Removing Chinese characters from certain rows in a column

I have a column (Column A) which contains Chinese characters in some rows. I want to get rid off them. Although I can do it manually, but sometimes there are a few hundreds rows containing the Chinese words. So it becomes tedious. I tried searching for codes that can help but so far those that I found do not seem to work. I have attached a sample file. I would appreciate it very much if someone can help me with coding to simplify the removal of the Chinese words only, leaving numbers and English words alone. Thank you.

Hi,

I don't know of a way to target a remove such characters.
I would add a helper column and enter sequential numbers starting with 1.
Then put a filter on the columns, and sort column A, A to Z. Manually delete the large sections of characters.
Use your helper column to put your original data back in order.

See attached modification of your data.

Hope this is helpful.

Cheers

Thank you for the suggestion. I'll give it a try.

I was able to sort Column A and did the removal of the Chinese characters and then using the helper column (Column B) to return the data to their original order. However, when I use the same method as you described on my actual data, I was able to sort Column A data from A to Z but the numbers in Column B (helper column) remain in their order. They didn't follow the data in Column A. So I'm unable to sort back to their original order again. Am I missing in doing something? Please let me know how the make the helper column numbers sort together with the data in Column A.
Thank you.

Thank you very much for the formulas. They work great. However the resulting data have every line filled. I need a blank row before every number, except the number 1. That is, before 2, there should be a blank row, another one before 3, and so on. Is there a way of inserting these blank rows automatically? I found some macros which insert blank rows at regular intervals but they can't work on the data on my worksheets. Somehow, the regular inserting of blank rows do not appear at the right places, that is, before each number. If you can help me with this, that would be great.

Hi,

Yes, you are missing a step.
Before you sort, you have to make sure you header cells, in this case should be A1 and B1 are set as filter headers.
To do this, select A1, under the Data ribbon/menu select Filter. This will set up A1 and B1 as your filter sets.

Cheers

Thank you very much. I can do it now.

I am glad to hear and glad that I could be of some assistance.

Cheers

Thank you, AlKey. Sorry that I didn't make my request clearer. Blank rows are now inserted above each number but I would want the rows occupied by the Chinese characters to be removed. Can your formula be changed to accommodate that? Thanks.