» Separating a Number Into Digits
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Separating the number in A2 into digits, so that each of cells B2:G2 will contain one digit.
Solution:
Using the MID and COLUMN functions, as follows:
=MID($A2,COLUMN()-1,1)
Book Store:
Recommended Books:
- Mastering Excel 2000 (for beginner)
- Microsoft Excel 2002 Formulas (With CD-ROM)
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Retire Young, Retire Rich
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Windows XP for Dummies
No comments have been submitted.
