What formula will extract numbers from a formula using any operator as the delimiter?
For example:
<tbody>
</tbody>
The invoice amount has a formula that is auto populated from our system and I want to separate the formula into 3 columns. Some lines may have more or less than 3 amounts in the formula.
For example:
Invoice Amount | Product 1 | Product 2 | Product 3 |
=4384+89463+9876 | 4384 | 89463 | 9876 |
<tbody>
</tbody>
The invoice amount has a formula that is auto populated from our system and I want to separate the formula into 3 columns. Some lines may have more or less than 3 amounts in the formula.