In a chart I keep, I have multiple numbers in each cell. For example; "300 000 + 600 000 - 400 000". The cell automatically calculates it into 500 000 and shows that into the cell, although when I click on the cell I can still view my original numbers. I wonder if there's a formula which would pick out the original numbers I have in each cell? I specifically want to pick out negative numbers and positive numbers. So for example; Positive: 300 000 + 600 000; Negative: - 400 000. I want to pick out a range of cells and automatically calculate the negatives or positives.
How can I do this?
How can I do this?
