You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

The Trim function requires a single reference to operate. For example, entering "=TRIM (A1)" without quotes will strip all but single spaces between words from the string " this is a test " in ...

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

This will open Excel for you to open a new document or open a recent document. 2] Enter the numbers in Excel cells You may have an Excel file where you have the numbers that you want to work on.