» 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:
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- East of Eden (Oprah's Book Club)
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The New Financial Order: Risk in the Twenty-First Century
- Analysis of Financial Statements
No comments have been submitted.
