Title: Remove Extra Spaces from Excel Data | Pryor Learning Solutions
Headings: Remove Extra Spaces from Excel Data
Remove Extra Spaces from Excel Data
Use the Trim Function
Use a Formula to Remove All Spaces
Bonus Hint!
Tepring Crocker

Content: Images were taken using Excel 2013 on the Windows 7 OS. Option 1
Use the Trim Function
The TRIM function removes all spaces from text except a single space between words. Use this function when you have text data that contains hidden spaces in the cell. In our example, you’ll see that there are multiple “Joe Smiths” in our data. At a glance, several of them even look the same. However, the # of Characters column reveals that there are hidden spaces buried in the text. Step 1
To use the TRIM function, you will need to create a temporary, or helper, column for the corrected data at the end of your spreadsheet. For the purposes of this demonstration, we’ve called the column “Trim.” To follow using our example above, download Excel Remove Spaces Formula Template
Step 2
Click in the first cell of the Trim column. On the Formulas tab, click the Text dropdown menu in the Functions group and select TRIM.