I want to enter a number in one cell and then in different cells have each
number appear. For example, I type 12345 in one cell and then have 1 in a
cell, 2 in a cell, 3 in a cell, 4 in a cell, and 5 in a cell. Is there a
formula to do this?

--

Rob