Sub decomposition()
Dim i as long, Dim MaValeur as Variant
MaValeur = Range("A1").Value
For i=1 to Len(MaValeur)
Range("B" & i).Value = left(MaValeur,1)
on local error resume next
Mavaleur = right(MaValeur, Len(MaValeur) - 1)
Next
End Sub