How to blur the middle phone number in wps table?

For privacy reasons, we usually blur the four digits in the middle of the mobile phone number. So how to operate specifically? Generally, it can be realized by automatic filling method and function formula method. Let me take WPS11.1.1.10 as an example to show you the specific operation steps.

Method 1: automatic filling method

Step 1: Open the WPS table, select the blank cell to the right of the phone number to be modified, and manually enter one as an example.

Step 2: Select the sample cell and other cells to be filled at the same time, and press Ctrl+E on the keyboard.

Step 3: You can see that other cells have been filled in as required, and the phone number in the middle is ambiguous.

Method 2: Function formula method

Step 1: Select the blank cell to the right of the cell to be modified.

Step 2: Enter the = replace (A 1, 4,4, "* * *") function in the edit box above, and then click Enter.

Step 3: Move the cursor to the lower right corner of the modified cell, hold down the left mouse button and drag it down to fill it automatically.

Step 4: You can see that other cells have been automatically filled in and modified, and the phone number in the middle has been blurred.