» 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:
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Special Edition Using Microsoft Outlook 2002
- Absolute Beginner's Guide to Microsoft Excel 2002
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Microsoft Windows XP Step by Step (With CD-ROM)
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
No comments have been submitted.
