I am trying to find a way to split the numbers from a cell with the following data in it:
With this data in a cell, in the adjacent 3 cells, I would like to see the results returned as thus 31 3 22
I have tried to use
=iferror(arrayformula(split(D2:D,"(")),"") but obviously I have to do this 5 times which takes up multiple extra lines. I would then plan to fill the column to cover over 10,000 lines (possibly).
Any ideas? Is there a way of building multiple array formulae in one go?