» 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:
- The Ernst & Young Business Plan Guide
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Learn MS Excel 2002 VBA/XML Programming
- Keys to Reading an Annual Report (Barron's Business Keys)
- Accounting Principles, with CD, 6th Edition
No comments have been submitted.
