Manipulating strings

Hi
Use in C2 this

Formula:

=ExpandStr(A2)

to expand the string to your desired format and then use in D2

Formula:

=Text2Column($C2,COLS($A$1:A$1))

and copy right to perform Text to columns.

See the file