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.

This post will show you how to remove the first or last few characters or certain position characters from the text in Microsoft Excel.