All, I have to separate a 6 digit number in 1 cell into 6 individual cells per row. Example.
123456 (A1) and need to be (A1 is 1, B1 is 2, C1 is 3, D1 is 4 etc.
Row 2 might be 568914 so I need row to to be (A2 is 5, B2 is 6, C2 is 8, D2 is 9, E2 is 1 and F2 is 4).

I have 1500 rows of current numbers and need to separate like i have explained.

I hope this makes sense to you all.

Michael