This article will explain how to remove spaces in a cell in Microsoft Excel 2007.
How to remove spaces in a cell in Microsoft Excel 2007 ?
There are times when the text value entered in a cell contains leading or trailing space characters which may cause some unexpected behavior when performing some operations.
The Excel provides a function called TRIM which can be used to remove leading and trailing spaces in the excel worksheet.
For Example , TRIM(A1) will remove the spaces from the text in the cell “A1″.