VBA in access splitting text in one column into same length text in other columns

[Kobierok]

Hi,

Im looking for a code which would allow me to split string/ text in one column ( which contains combined 5 length strings max 6 of them) into other access columns, each column should contain one 5 sings string.

I looked up all the build in formulas but none of them fully responds to this. Can anyone struggled with similar case already?

 

[Joe4]

How are these string separated in the column? Are they separated by commas, or something else?
We need some way of determining where to break up this string. Can you tell us what that logic is?

It may be helpful if you also post a few actual examples.