» 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:
- Special Edition Using Microsoft Excel 2002
- Excel 2002 For Dummies®
- Business Analysis with Microsoft Excel (2nd Edition)
- Adventure Capitalist: The Ultimate Road Trip
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Good to Great: Why Some Companies Make the Leap... and Others Don't
No comments have been submitted.
