Text To Column Based on Start and End Position

[noeyez]

Hello,
I tried searching thru the forum but I couldn't find an answer to this question:

I have a string of text that I would like to put into columns based on the start and end position. For example, this is my text:

123ABC456DEF

Column 1 would be from position 0 - 4
Column 2 would be from position 5 - 6
Column 3 would be from 7 - 10

123A | BC | 456DEF

Is this possible?

[stnkynts]

Possible, yes. The unanswered question however is where does the text come from. Here is code where I assumed the text was in "E1".
Also, your post is erroneous. You stated column 3 would be from 7 - 10 but your example is actually 7 - 12. I assumed you meant 7 - 12

Please Login or Register  to view this content.

I also assumed you wanted to do this via VBA. This is perfectly possible via formula.

[noeyez]

Thanks! Would it be possible then to loop it for multiple rows of data? the text would be in A1 - A3

[AlphaFrog]

Maybe something like this (assumes column A is the data column)

Please Login or Register  to view this content.