How to remove space characters in excel

Removal method: First click on the specified cell, click "Formulas" - "Insert Function" at the top of the page; then enter "SUBSTITUTE" and click Find Function; then enter the text to be edited in "String" Cell, enter " " in "Source String", enter "" in "New String"; finally press the "OK" key on the keyboard.

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

Use the function "SUBSTITUTE" to remove space characters in EXCEL cells in batches. Please refer to the following steps for specific operations.

First open the target excel file on your computer and click on the cell to be edited with the mouse.

Then click the "Insert Function" option in the menu option "Formulas" page.

Then enter "SUBSTITUTE" in the function dialog box and click Find Function.

Next set the function parameters and enter the text cell to be edited in "String".

Then enter " " in "Source String" (Note: Entering a space between the quotation marks means modifying the place with spaces).

Then enter "" in "New String" (note: do not enter spaces between the quotation marks, which means it will be modified to have no spaces).

#After clicking OK, drag the cells to delete the spaces in batches. After completing the above settings, you can remove space characters in EXCEL cells in batches.

Related learning recommendations: excel tutorial

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