How do I quickly separate English strings in Excel tables?

Excel Tutorials

How do I quickly separate English strings in Excel tables?

A fixed number of Chinese and English separation

1, if the Excel cell, Chinese and English together, but the number of Chinese fixed (for example, in the illustration case, the first 2 characters in the cell is Chinese). We can consider using a simple formula to implement a quick split cell.

2, in the cell B1 input formula =left (a1,2), you can get the cell before the Chinese string.

3, in the cell C1 input formula =right (A1,len (A1)-2), you can get the cell before the English string.

4, then, we select the range of cells b1:c1, pull down the formula, that is, automatically fill down. You can quickly get the effect of separating cells in English.

Ii. non-fixed number of Chinese and English separation

1, below we look at a slightly more complex in English and Chinese, how to automatically separate. For example, in the illustration case, the number of Chinese is not fixed.

2, in the cell B1 input formula =left (A1,lenb (A1)-len (A1)), you can quickly split the Chinese (number of characters are not fixed).

3, in the cell C1 input formula =right (A1,len (A1) *2-lenb (A1)), you can quickly split English.

4, again, we select the range of cells b1:c1, pull down the formula, that is, automatically fill down. Can quickly get the effect of splitting cells in English

Note:

The separation of English and Chinese, the first observation of the law can be followed, the usual use, consider compatibility, you can use the final formula of the article