Zend certified PHP/Magento developer

Split a long text into multiple cells in excel

I have a long text string which looks like this: (213412=a)(223412=b)(512231=c)…

I want to split this into multiple cells sitting below each other where each cell gets a string of the same size. Maybe 6 of those character bits in brackets each. How can I accomplish this?

I tried the MID formula which is generally doing what I want, however I cant seem to expand it with autofill