HOW TO BULK DELETE CERTAIN CHARACTERS IN EXCEL Chinese CHARACTERS

Let's say yours are all in column A, starting with A1.

Then write =left(a1,find() on b1"groups", a1)), and then fill down column b to get column b that meets your requirements.

Let's say the data is in column A.

b1 Enter the formula.

mid(a1,900,99999)

Double-click the fill handle.

Copy column b and paste it selectively as a value.

You'd better know exactly how many words there are, say 900, then =right(a1,len(a1)-900).

How to delete part of the content in batches in excel, the following are the basic steps to delete part of the content in batches.

1. First of all, open Excel** in your computer and enter the content.

2. Select a cell, and then select Cell Processing in Document Assistant.

3. Then select Remove Content.

4. Then in the window that opens, check the filter type and click OK.

5. In this way, some of the content is deleted in batches.

1. First of all, select the cells that need to keep the first three words in the open Excel**.

2. Then click on the "Data" option in the toolbar above.

3. After entering, click on the "Column" option in the "Data" tab.

4. You can open the column wizard dialog box, click "Fixed Width" in it, and click Next.

5. Then click the left mouse button on the right side of the third word, and click the next button when the arrow style in the following picture appears.

6. Click Done on the new page to split the selected cells and delete the unwanted parts.

1. Turn on the computer, and then open an excel** on the computer desktop, for example, we want to delete all cells containing the word "hello";

2. Click "Sort and Filter" in the toolbar, and then click "Filter", you will find a small triangle logo in column A, click on the triangle logo, and then click on the "Text Filter" option;

3. Then click "Contain" to enter the word "Hello" that you want to delete, and then click the "OK" option;

4. Then find that all the cells containing "Hello" are filtered out, at this time, select all rows, right-click, and then click "Delete Row" to delete.

1. Select column B, and click "Data" - Columns.

2. Click "Next" in the pop-up window. Wantonly.

3. Check "Other" to enter the "Symbol" you want to remove, and click "Next".

4. Click "General" in the red circle in the picture below, and a black background will appear in the selected place after clicking.

5. Select "Do not import this column" and click "Split World Lu Complete" in the lower right corner.

6. Only the name remains.