Title: Remove Spaces in Excel (Examples) | How To Remove Spaces?
Headings: Excel Remove Spaces
Excel Remove Spaces
Excel Remove Spaces (Table of Contents)
Introduction to Remove Spaces in Excel
Different Types Of Spaces
TRIM Function
How to Remove Extra Spaces in Excel?
Example #1 – Remove Excel Spaces with the help of Find and Replace
Example #2 – Remove Excel Spaces with the help of TRIM Function
Example #3 – Remove Excel Spaces with the help of SUBSTITUTE Function
Things to Remember about Excel Remove Spaces
Recommended Articles

Content: Let’s understand the working of removing extra spaces in excel with the help of some examples. You can download this Remove Spaces Excel Template here – Remove Spaces Excel Template
Example #1 – Remove Excel Spaces with the help of Find and Replace
In the below-mentioned example, I have a dataset in column D that contains all three types of extra spaces, i.e. Leading spaces, Trailing spaces & Extra in-between spaces. For reference, I have done a number of character count for the column D datasets. With the help of the LEN function in column E., I have taken this raw data to another new column (column H) to apply the Find and Replace task. Now, I have to select the cell range where the Find and Replace parameter needs to be applied to remove extra spaces in excel. Now, to activate the find and replace option, press the shortcut key Ctrl + H, find and replace window appears. In Find what: input bar, insert a blank space with the help of the space bar once, and in Replace with no need to input anything, it should remain blank. Click on the Replace All button. It replaces all the blank spaces in the cell.