Calculate Number in Brackets/Parenthesis

[eowplum]

Is it possible to extract a number in brackets specifically from a cell, then increase it by 15%, and return the result back into the brackets.

For example the cell consists the following:
Mary (78)

so the aim is to get the 78 out for calculation, then change the content of the cell with the new result.

Or is there a macros that can be created for this?

[Dave Hawley]

One way

=--SUBSTITUTE(MID(A1,FIND("(",A1)+1,256),")","")+(SUBSTITUTE(MID(A1,FIND("(",A1)+1,256),")","")*15%)

Or use Edit Replace and replace the ( and ) with nothing. Then copy any cell housing .15 then select the resulting numbers (after Edit>Replace) and go to Edit>Paste Special - Value - Multiply - OK

[Dave Hawley]

BTW, if the numbers is placed back into brackets it will again become text. So use a Custom Number Format like "("0.00")"

[eowplum]

Thx real much.
Just additionally asking.

Is it possible to change a cell from Mary (78) to Mary (89.7)?
Doing the same operation, but at the end keeping the text format?

i'm a total excel idiot...

[Dave Hawley]

How about Edit>Replace and replace ) with .7)

[eowplum]

Thx real much, I understand everything now!