How to extract the Chinese content from the mixed text in EXCEL

Answer 1

To extract the Chinese content from the mixed Chinese and English text in Excel, you can use the following steps:

1. Enter text that contains Chinese into Excel. You can use a terminator such as commas or semi-colons to separate the text into different parts.

2. Choose the cell you want to extract Chinese content from. You can use the "filter" function to identify the Chinese content in the cell. The specific steps are as follows:

- In the "Data" tab, select the cell you want to filter;

- In the "format" tab, select the "filter" tab.

- In the "Advanced" option, select "select the entire cell" in the "List area and value" drop-down menu;

- In the "Condition" option, select "Equal" and "Chinese Text";;

- After clicking the "OK" button, the filter would be completed.

If you are using Excel 2016 or above, you can use the "conditioned format" function to display Chinese text. The specific steps are as follows:

- In the "Data" tab, select the cell you want to filter;

- In the "format" tab, select the "shade" tab.

- In the "Shading" tab, choose "White" from the "font color" drop-down menu.

- In the "Shading" tab, choose "Center" from the "Alignment" drop-down menu;

- You can complete the settings by clicking the "OK" button.

3. Using formulas to extract Chinese content, you can use the following formulas:

=IF(SUMPPROCEST ({1;2;3}A1:A100)=IF({1;2;3} Chinese text)) Chinese text)

This formula will return Chinese text in cells that contain Chinese text. If all cells contain Chinese text, return Chinese text. Otherwise, return a blank value.