Tip Printed from ExcelTip.com

---

Separating a Number Into Digits


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)