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

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number ...