Cube Long Arrow Right External Link angle-right Search Times Spinner angle-left

Remove Extra Spaces from Excel Sheet

For one formatting reason or another, you may discover there are extra spaces in the cells of your Excel mailing list. This creates a displeasing appearance in the recipient address block and while populating mail merge fields. undefined

undefined

You can remove those extra spaces by using the TRIM function in Excel. To remove the extra spaces preceding the data in a cell, enter the trim formula in the destination cell.

undefined

After hitting enter, the extra spaces preceding the data are removed.  To remove the extra spaces in the remaining cells, highlight the destination cells.

undefined

After highlighting the destination cells, select Home, Fill and Down to achieve the results seen below.

undefined