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