Basic help. sum of a cell that has a maths function

vkkindia · October 12, 2023, 8:03am

A cell A1 has a expression of 10+5

I need to find sum of A1, if i give sum(A1) i get 0.

karolus · October 12, 2023, 8:16am

Hallo
select A1
ctrl+H (search and replace):
search for ^.*$ replace with =&
with Options:

[x] regular Expression 
[x] Selection only

→→replace all

vkkindia · October 12, 2023, 8:25am

thanks for your reply, but sorry my requirement is this cell should not be changed, I need to get the sum so that i can use in another functions. like in another cell it has (A1/A10)

karolus · October 12, 2023, 8:32am

So enter =A1 into B1, and do the procedure above on B1

schiavinatto · October 12, 2023, 10:15am

Hello @vkkindia ,

=LEFT(A1;SEARCH("+";A1;1)-1)+RIGHT(A1;LEN(A1)-SEARCH("+";A1;1))

vkkindia · October 13, 2023, 12:02pm

Thanks, it works.

I used another logic of using mid. this also works. (but yours is better)

Lupp · October 13, 2023, 3:24pm

Only for specifically interested users I tried again and found that currently (V7.6.1.2 for me) Option VBAsuppport 1 again relieves restrictions concerning side effects of UDFs.
This made an “evaluator function” work for me. See attached example.
Actual use “in production” is strictly discouraged!
experimntalEvaluator.ods (24.0 KB)