littlepuppy
New Member
- Joined
- Jun 8, 2015
- Messages
- 2
Hey guys,
I want to extract the numbers out from the formula in excel.
For example,
30=9+8+7+6 the number in the cell is 30. The 30 comes from 4 different numbers. I want to get each of the number out separately, like 9, 8, 7, and 6. each of them separately.
8,450,668.83=38062098.32-29611347.24-82.25
Same as here. The cell number 8,450,668.83 comes from three different numbers. How to get 38062098.32, -29611347.24, -82.25 out and each of them separately.
Thank you
I want to extract the numbers out from the formula in excel.
For example,
30=9+8+7+6 the number in the cell is 30. The 30 comes from 4 different numbers. I want to get each of the number out separately, like 9, 8, 7, and 6. each of them separately.
8,450,668.83=38062098.32-29611347.24-82.25
Same as here. The cell number 8,450,668.83 comes from three different numbers. How to get 38062098.32, -29611347.24, -82.25 out and each of them separately.
Thank you