How to replace numbers in excel table

Method to replace numbers in the excel table: First click [Find] and select [Replace]; then enter the content to be replaced in the search content; then enter the content to be replaced in the replacement column; finally Click the [Replace All] button.

Method to replace the numbers in the excel table:

1. For the serial number in the following table, replace the previous Change the serial number "9122" to "9438", press the combination shortcut key Ctrl H, or as follows:

#2, or select Search in the Start menu in the menu bar, Pull down and select "Replace", as follows:

3. How to simply replace Excel table data. A dialog box will pop up. Enter the content to be replaced "9122" in the search content above. , and then enter the content to be replaced "9438" in the replacement column, as shown in the figure:

4. Then click the "Replace All" button, in the number table All the sequence values will be changed to values starting with "9438", as follows:

5. After clicking Replace All on the lower left, you will be prompted that 26 replacements have been made. Just click OK and close the "Replace" dialog box.

Related learning recommendations:excel basic tutorial

The above is the detailed content of How to replace numbers in excel table. For more information, please follow other related articles on the PHP Chinese website!