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: Easily remove leading, trailing, extra or all spaces in cells





Remove spaces in Excel cells – leading spaces, trailing spaces, extra spaces or all spaces
Sometimes, when data has been copied and pasted from other applications into a worksheet, something may go wrong if extra spaces unconsciously coming along with the data. For example, when adding two number cells which including leading spaces, it will return the result as 0 instead of the correct result; Or get the wrong result while comparing two cells with the same content but one of them containing leading or trailing spaces. How to remove these spaces? This tutorial will introduce several methods for you. Remove extra spaces including leading, trailing and excess in-between spaces from cells
Remove only leading spaces from cells
Remove only trailing spaces from cells
Remove all spaces from cells
Easily remove leading, trailing, extra and all spaces from cells with an amazing feature
Remove extra spaces including leading, trailing and excess in-between spaces from cells
Supposing you have a column list of cells containing leading, trailing, and excess in-between spaces. For removing all these extra spaces from cells, the TRIM function can help. =TRIM (TEXT)
Select a blank cell, enter =TRIM (B3) into it and press the Enter key. And then drag its Fill Handle down to apply the formula to other cells. See screenshot: