1, open WPS to create a new blank table and edit the data;

2. Put the mouse in the B2 cell, enter the formula "= replace (A2, 7, 4, * * * *)", and then click Enter.

3. Click the B2 cell in the lower right corner, hold it down and drag it down to the last cell to get the data.