Title: Easily remove leading, trailing, extra or all spaces in cells
Headings: Remove spaces in Excel cells – leading spaces, trailing spaces, extra spaces or all spaces
Remove spaces in Excel cells – leading spaces, trailing spaces, extra spaces or all spaces
Remove extra spaces including leading, trailing and excess in-between spaces from cells
Several Clicks To Remove Unneeded Spaces From Cells
Remove only leading spaces from cells
Use MID function to remove leading spaces only
=MID (B3,FIND (MID (TRIM (B3),1,1),B3),LEN (B3))
Use VBA code to remove leading spaces only
Remove only trailing spaces from cells
Remove all spaces from cells
Use SUBSTITUTE function to remove all spaces from cells
=SUBSTITUTE (B3," ","")
Use Find & Replace function to remove all spaces from cells
Easily remove leading, trailing, extra and all spaces from cells with the Kutools
Other practical cases related to Excel spaces
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Office Tab - brings tabbed interface to Office, and make your work much easier

Content: After removing all extra spaces, you need to replace the original data with the trimmed data by pressing the Ctrl + C, select the original data range and right click to select Values under the Paste Options section. Several Clicks To Remove Unneeded Spaces From Cells
With the Remove Spaces utility, only several clicks can help you removing not only leading spaces, trailing spaces, excess spaces but also all spaces from a range, multiple ranges or even the whole worksheet, which will save a lot of your working time. Kutools for Excel - Gathers more than 300 powerful advanced features, designed for 1500+ work scenarios, solve 80% Excel problems. Download and try the full feature free trial 30-day
Remove only leading spaces from cells
In some cases, you may need to remove the leading spaces only and keep all in-between spaces in cells as the below screenshot shown. This section introduce another formula and VBA code to solve this problem. Use MID function to remove leading spaces only
Select a blank cell (here I select cell D3), copy the below formula into it and press the Enter key. And then drag the Fill Handle down to apply the formula to other cells. =MID (B3,FIND (MID (TRIM (B3),1,1),B3),LEN (B3))
In this formula, B3 is the cell containing the text from which you want leading spaces to be removed. Note: This operation needs to be done in a new column.