» Problem: Unnecessary Empty Characters in Cells
CATEGORY - Excel Tools
VERSION - All Microsoft Excel Versions
To remove empty 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.
Book Store:
Recommended Books:
- Accounting the Easy Way
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Windows XP All-in-One Desk Reference For Dummies
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- The Interpretation of Financial Statements
No comments have been submitted.
