» Add space between characters and numbers in Microsoft Excel
CATEGORY - Excel Editing , Excel Formula
VERSION - All Microsoft Excel Versions
data in cell A1: A100 Formula in cell B1: =LEFT(A1,1)&" "&RIGHT(A1,LEN(A1)-1) Result: A 100
Book Store:
Recommended Books:
- Accounting Principles, with CD, 6th Edition
- How to Use Financial Statements: A Guide to Understanding the Numbers
- A Mathematician Plays the Stock Market
- Windows XP Annoyances
- Accounting and Financial Fundamentals for Nonfinancial Executives
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
No comments have been submitted.
