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.

Text in a cell in Excel is called a text string. Excel provides a number of built-in functions enabling you to select and manipulate text strings in cells. The easiest way to identify or extract a ...

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