Home > Topics > excel > How to remove space characters in excel

How to remove space characters in excel

醉折花枝作酒筹
Release: 2021-05-12 14:36:52
Original
33519 people have browsed it

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.

How to remove space characters in excel

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.

How to remove space characters in excel

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

How to remove space characters in excel

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

How to remove space characters in excel

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

How to remove space characters in excel

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

How to remove space characters in excel

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

How to remove space characters in excel

#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.

How to remove space characters in excel

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template