Supposing you need to break or split number into individual digits as below screenshot shown, what can you do to achieve it? This article will provide Formulla for you.
1. Select a blank cell (says cell C1) for locating the first split digit of number in cell A1, then enter formula =MID($A1,COLUMN()-(COLUMN($C1)- 1),1) into the formula bar, and then press the Enter key.
Note: In the formula, A1 is the cell with number you need to split to digits, and C1 is the cell for locating the first split digit. Please change them as you need.
2. Keep selecting cell C1, then drag the Fill Handle to the right cells until all digits of cell A1 are split out.
3. Keep these split digit cells selected, and drag the Fill Handle down to the cells until all numbers are split into separated digits. See screenshot:
- Thank You For Visit.
This comment has been removed by the author.
ReplyDelete