Distributing string\char to each cells

Hi,

A1: = 1234 (INTEGER)

How do I distribute each number to each cell. For example, I would like to put 1 on C1, 2 on D1, 3 on E1, and 4 on F1.

Please help.

Thanks

In C1 and copy right, =MID($A1, COLUMN() - 2, 1)

SHG : Your formula gives me the "8" instead of the "4"

Originally Posted by NBVC

Try:

=MID($A$1,COLUMN(A$1),1)+0

copied across

It works! **