How to extract and split this set of numbers (314.81+10.00)+0.00 to each column
expected result:
Try in W1
=ARRAYFORMULA(value(split(regexreplace(V1, "\(|\)",), "+")))
and see if that works?