Yet, there's one more operation I need to carry out that I forgot to mention.

I need to divide into two those cells containing a string of Chinese characters follow by a string of Latin ones, which are separated by a space, so that each string of different scripts belong to a different column. These cells always appear in the second colum of a block of four columns.

Supposing one block of four columns, and four rows as a mere example
Captura.JPG

Finally, a new sheet/page of four columns, A-D, would contain all the fixed rows.

Here's the whole document I need to process elastic list.perpage50.xlsx

Please, notice the the last row of each page (number 42, except for the las page 61, which is number 6) just contains merged cells with the number of page, so these rows should not be taken into account, and if possible deleted.

I am afraid I am a newbie, so I trust your recommendations. I hope the whole process can be fully automated.

If any further clarification is necessary, please let me know.