» 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:
- Financial Risk Manager Handbook, Second Edition
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- The New Financial Order: Risk in the Twenty-First Century
- How to Pay Zero Taxes (Annual)
- Windows XP for Dummies
No comments have been submitted.
