I have written a blog post on how to do this, please take a look.
https://blog.exploratory.io/quick-tip-split-a-sequence-of-numbers-or-letters-into-multiple-columns-87257e88a546#.2qnm7u1e4