Split long string into separate strings of X length

betapaul · May 17th 2011

So I have one cell with about 931 characters (all numbers). I want to separate them out in groups of 7 into 133 separate cells starting with the first number.

I know how to do it if I put

=mid(a1,1,7)

in all 133 cells and change the middle number, but I don't want to do that. Any other way?

AAE · May 18th 2011

Re: Split long string into separate strings of X length

betapaul,

Note the change to your thread title and try to be a bit more accurate going forward.

Please do not use code tags with formula --- they are reserved only for use with VBA code.

Thanks.

Armando Montes · May 18th 2011

Re: Split long string into separate strings of X length

Try this:
B1: =LEFT($A1,7)
C1: =MID($A1,COLUMN()*7-13,7)

Split long string into separate strings of X length

Participate now!

Share