Extract numbers from a sum formula inside a cell

Hello all,

after searching for a solution all over the internet, without success, I've decided to ask the masters of vba excel present on this forum

I need to extract the numbers from a sum inside a cell.

Ex: in cell A1 I have the formula "=150+50+100"
I need to extract the separate numbers from that formula to different cells
The result I need is: A2 = 150, A3 = 50, A4 = 100

Can anyone help me? Thanks in advance.

Cycloneclau

How is this to be done?

As a formula?

As A macro?

Is the data always in that format or do we need to consider other operators, ie -, /, *,^.

How is this to be done?

As a formula?

As A macro?

Is the data always in that format or do we need to consider other operators, ie -, /, *,^.

This is a formula based approach.

Thanks for your help. I think that the tect to column approach will fit into my macro.
When I have some time I will try the formula sent by you too, checking which is faster.

Thanks
Cycloneclau