» Unnecessary Blank Characters in Cells in Excel 2007
CATEGORY - Excel Importing Text Files
VERSION - Microsoft Excel 2007
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.
Book Store:
Recommended Books:
- Dictionary of Finance and Investment Terms
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Wall Street Journal Guide to Understanding Money and Investing
- Financial Risk Manager Handbook, Second Edition
- The Ernst & Young Business Plan Guide
No comments have been submitted.
