Place individual digits from a number into seperate cells

[TallTony]

Hello All,

I need to place each digit from a number into its own cell.

For example the number 123 I need 1 to be in cell b1, 2 to be in c1, and 3 to be in cell d1. Each of the original numbers can be upto to 6 digits long and there are over 200,000 rows of data, so too many to do manually.

I tried=LEFT(A1,LEN(A1)-1) etc, but that only seems to work with Text

Any help would be greatly appreciated.

Thank you,