However carefully you monitor the data you enter and import into Microsoft Excel, and the output of formulas and functions that produce new values, it's easy to wind up with cells that contain one or ...

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

Do not confuse a space in the Replace With text field with an empty text field. If you press the space bar in the Replace With text field, Excel will replace all instances of that punctuation with ...