Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Unnecessary Blank Characters in Cells in 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.

Rate this tip
12 34 5
  RATING: 5.00
  VIEWS: 1905
  No comments have been submitted.


REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


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.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation