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.

You can use Excel's built-in substitute function to remove or replace a substring of a string of characters in Excel. This can include removing hyphens from Social Security numbers or any other ...