Splitting String

[GiacTorrence]

Hi all,

I'm trying to find a method for splitting this string of numbers (currently all in one cell), into separate, individual cells, (forty, in this case).

4412422243432131224342123322431331444324 Any suggestions would be much appreciated, thank you!

<tbody>
</tbody>

 

[bbott]

You can use Text To Columns on the Data tab. Select the Fixed Width option and insert a break between each. You should only have to do this once for the entire column.

 

[GiacTorrence]

Thanks so much!

 

[bbott]

Thanks so much!

You're welcome.