Removing these leading spaces – or trailing spaces that fall at the end of a cell's contents – requires an Excel function. Click in the first cell of a blank column on your spreadsheet.

If you apply this formula to a number, it will remove leading and trailing spaces but limit the in-between spaces to 1. For removing all the spaces from numbers, you may use the next two methods.

How to Remove Whitespace From a String in Excel. ... (ASCII character 160) in cell "A1" with standard spaces (ASCII character 32) and then trims leading, trailing and repetitive spaces. ...