|
» Unnecessary Blank Characters in Cells in Excel 2007
CATEGORY: Excel Importing Text Files |
VERSIONS: Microsoft Excel 2007 |
|
To remove blank characters, use the Trim function. The Trim function is in the Text category in the Insert Function dialog box. To insert the Trim function: 1. Select a cell and type: =Trim 2. Press Ctrl+A to open the Function Arguments dialog box. 3. Select the first cell in an adjacent column, copy/paste the formula to as many cells in the column as needed. 4. Copy the column and paste it as values. 
|
|
RATING:
5.00
VIEWS: 1905 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
