How to delete spaces in excel

Method: First open the excel table that needs to be operated, select the cells that need to delete spaces; then press the "ctrl h" key on the keyboard to pop up the "Replace" window; finally in the "Find content" input box Enter "Spacebar" in the "Replace with" input box, fill in nothing, and click "Replace All".

The operating environment of this tutorial: windows7 system, WPS Office2016 version, Dell G3 computer.

Enter the excel table, as shown in the picture. There are many spaces in the name column. The simplest method here is to use the substitution method to directly remove the spaces. Click the shortcut key ctrl h.

#The replacement dialog box pops up, enter a space bar in the search content, the replacement content is partially blank, and fill in nothing. Then click [Replace All]. All spaces are eliminated directly.

Related learning recommendations:excel tutorial

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