How to replace the second character of a name in Excel with an asterisk

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!