The method of replacing partial text in batches in Excel is as follows:

Tools/materials: Lenovo Xiaoxin, win10, Excel2016.

1. For example, you need to replace the last two digits of each cell number in the picture below with *.

2. We can first select the cells adjacent to the first row of content.

3. Then click the mouse in the editing bar.

4. Enter =REPLACE(B3,5,2,"**") in the edit bar

5. REPLACE is a function of Excel that can replace the specified The number of characters and bytes, (B3,5,2,"**"), B3 is the name of the cell on the left containing the content to be replaced, 5 means to replace from the fifth position, 2 means a * **Replace 2 digits, "**" means replace with two * signs.

6. After pressing the Enter key on the keyboard, Excel will automatically complete the replacement.

7. Then fill in the cells, and Excel will automatically complete the replacement of other cells.