Method: First open the excel table that needs to be operated, select the specified cell; then enter the formula "=replace (the cell that is set to an asterisk, start from the number of the cell to be set to an asterisk). number, how many characters to replace, "*")"; finally press the "Enter key" on the keyboard.
The operating environment of this tutorial: windows7 system, wps office2019 version, Dell G3 computer.
Open the excel table that needs to be operated, select the specified cell; then enter the formula "=replace (the cell set to asterisk, starting from the number of words set to asterisk, replace) in the cell How many characters, "*")"; finally press the "Enter key" on the keyboard.
Then drag down to fill in
Related learning recommendations: excel tutorial
The above is the detailed content of How to replace the second character of a name in Excel with an asterisk. For more information, please follow other related articles on the PHP Chinese website!