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

The SUBSTITUTE function in Excel is used to replace a particular text with another text. Here, we will show you how to use the SUBSTITUTE function to remove dashes in Excel.

If your data contains these characters, you need to use a different technique. The Substitute and/or Trim function can remove these characters using the following formulas: ...

Open your spreadsheet in Excel and locate the cells containing the whitespace that needs to be removed. Use the Trim function to remove whitespace created from normal spaces.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.