Removing extra spaces from cells with Trim in Excel
If you have data that contains additional spaces, there is a function you can use to trim them out.
- Select a destination cell for your formula.
- Type =trim([cell name]), then press Enter.
Note: According to Excel’s Insert Function dialog box, “Trim removes all spaces from a text string except for a single space between words.”