» 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:
- Marketing Plans That Work, Targeting Growth and Profitability
- Financial Risk Manager Handbook, Second Edition
- Special Edition Using Microsoft Outlook 2002
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- East of Eden (Oprah's Book Club)
No comments have been submitted.
