You can use the MID() function, comme ca:
=MID(A1,1,1)
=MID(A1,2,1)
etc. You could also use RIGHT() and LEFT() for the columns on the
extreme ends, if you like.