» 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:
- Harry Potter and the Order of the Phoenix (Book 5)
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Windows XP for Dummies
- Microsoft Excel 2002 Simply Visual
No comments have been submitted.
