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: Example #2 – Remove Excel Spaces with the help of TRIM Function
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 G) to apply the TRIM Function . The Excel TRIM function removes all spaces from text except a single space between words. Now, In cell H4, let’s apply a TRIM function. In the Formulas tab, click the Text drop-down menu in the Functions section and select TRIM. Now the function argument dialog box appears, click on the cell G4, which contains the text where I would like to remove spaces to complete the function, then click on OK. Now, you can observe in cell H4, where trim function removes leading space in that cell. Similarly, a TRIM function is applied to other range by selecting the cell H4 and drag it to H9 and click Ctrl+D to apply to the rest of the cells. You can find a difference in character count between both datasets where TRIM Function removes all spaces before and after the text in the cell (i.e. G4, G5, G6 & G7) & consecutive spaces in the middle of a string in the cell G8 & G9.