» Separating a Number Into Digits
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- Investing in Real Estate, Fourth Edition
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Windows XP for Dummies
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Microsoft Windows XP Inside Out
No comments have been submitted.
