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.

1. Select a destination cell for your formula.


2. 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."