» 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
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- The Basics of Finance: Financial Tools for Non Financial Managers
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
