SUBSTITUTE () is another text function that lets you replace an existing text with a new text in Excel. You may use this function to remove all the spaces (leading, trailing, and all in-between ...

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.