Home > Topics > excel > body text

How to delete spaces in excel

醉折花枝作酒筹
Release: 2023-01-13 00:42:16
Original
54951 people have browsed it

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

How to delete spaces in excel

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.

How to delete spaces in excel

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

How to delete spaces in excel

How to delete spaces in excel

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!

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